如何合并这些 mysql 语句 [英] How can I merge these mysql statements

问题描述

我有 2 个正在运行的 MYSQL 语句，我想将它们合并到 1 个查询中:

I have 2 working MYSQL statements, that I would like to merge into 1 query:

来自 mysql select 语句具有唯一和最大选择? 我有:

SELECT field_a, max(dup_number) as dup FROM table1 GROUP BY field_a

我的第二个查询是:

where contacts=0 ORDER BY date LIMIT 3

所以一组记录的示意图如下:

so a group of records would look schematically like:

ID     FIELD A     DUP_NUMBER  CONTACTS 
1       text1        0           1        --
2       text2        0           3        --
3       text2        1           3         --
4       text2        2           3        --
5       text3        0           2        --

我想出了:

SELECT *
FROM `table1 `
where max(`DUP_NUMBER `) as dup  and `CONTACTS`=1
GROUP BY `FIELD_A`
ORDER BY date
LIMIT 3

当我在 PHPMyAdmin 中测试时，我得到

When I test in PHPMyAdmin I get

#1064 - You have an error in your SQL syntax.

谁能告诉我如何正确地重写它?

Can anyone show me how to rewrite this correctly?

推荐答案

试试这个.

SELECT *, max(DUP_NUMBER) as dup FROM table1 where  CONTACTS=1 GROUP BY FIELD_A ORDER BY date LIMIT 3

这篇关于如何合并这些 mysql 语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！