Question

SQL数据库 字段C去重 同时取字段A最大值

数据表如下
A B C D
goodscostid goodsid shopid cost
3561 32646 C004 44.94
154020 32646 C004 44.94
4271 32647 C009 67.08
249738 32646 C004 44.94
438620 32646 C004 44.94
4725 32646 C008 44.94
4287 38759 C004 50.00
4270 32646 C009 44.94
352018 32646 C009 44.94
46848 32646 C010 44.94
4287 32680 C009 17.12
4287 73075 C014 56.55
140384 32646 C010 44.94
369619 32646 C010 44.94
4289 38762 C004 43.00
4270 32646 C009 44.94
我想通过一条语句 实现查询结果如下：

A B C D
goodscostid goodsid shopid cost
438620 32646 C004 44.9400
4725 32646 C008 44.9400
352018 32646 C009 44.9400
369619 32646 C010 44.9400
条件：字段A最大值 字段B32646 字段C去重 显示A,B,C,D
求大牛出代码！

Answer 1

select max(A), max(B), C, max(D)
from 表名
group by C
即可

追问

如果显示这种字段名 我在 调用的时候 怎么写？ 直接用field1 或fieled2 ？

追答

select max(A) AS field1, max(B) AS field2, C as shopid, max(D) as field4

from 表名
group by C

追问

太感谢了！！~ 已解决！！~