Question

SQL分组查询 每个分组取一个数据

求高手

Answer 1

表名假定为g，字段为id,group,name
我用sql server写的
语法应该是一样的
语句如下：

select * from g g1
where g1.id in
(select top 1 g2.id from g g2 where g2.[group]=g1.[group] order by g2.id)
order by g1.id

Answer 2

select top 1 id，count(A) from 表名 group by id

Answer 3

能详细说明吗。