这是一个创建于 1755 天前的主题，其中的信息可能已经有所发展或是发生改变。
select id, max(field_d)
from table_name
group by field_a,field_b,field_c;
报错了 id must appear in the GROUP BY clause or be used in an aggregate function
所以 是不是只能用子查询了?
SELECT ID
FROM
table_name
WHERE
( field_a, field_b, field_c, field_d) IN (
SELECT
"field_a",
"field_b",
"field_c",
MAX ( field_d ) AS "field_d"
FROM
"table_name"
GROUP BY
field_a,
"field_b",
"field_c"
ORDER BY
"field_a" DESC
);
谢谢
from table_name
group by field_a,field_b,field_c;
报错了 id must appear in the GROUP BY clause or be used in an aggregate function
所以 是不是只能用子查询了?
SELECT ID
FROM
table_name
WHERE
( field_a, field_b, field_c, field_d) IN (
SELECT
"field_a",
"field_b",
"field_c",
MAX ( field_d ) AS "field_d"
FROM
"table_name"
GROUP BY
field_a,
"field_b",
"field_c"
ORDER BY
"field_a" DESC
);
谢谢
 |
1
chaleaoch OP sorry 忘记用 md 了 排版感人.
|
 |
2
glacer 2020-02-07 16:23:17 +08:00
id 放 group by 里...
|
 |
4
liprais 2020-02-07 16:27:10 +08:00
看不懂你想要啥
|
1
Select Language