这是一个创建于 1975 天前的主题，其中的信息可能已经有所发展或是发生改变。
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
F281M6Dh8DXpD1g2 2020-02-07 16:27:10 +08:00
看不懂你想要啥
|
|
8
F281M6Dh8DXpD1g2 2020-02-07 16:35:18 +08:00  1
@chaleaoch
d 没有重复的话可以这样写 select id from table t0 join ( select max(d) as d from table group by a,b,c ) t1 on t0.d = t1.d 如果有重复的话，你需要写清楚到底要哪一条 |
Select Language