如何取安名称和时间分组后，分组最近的一条记录
ID No Name Price EditTime
1 C1 112-20114 0.154 2004-08-03 11:59:40.000
2 C1 112-20114 0.652 2004-08-20 11:59:40.000
3 C1 112-20151 0.251 2004-08-12 09:59:40.000
4 C1 112-20151 4.1587 2004-07-12 09:59:40.000
5 C1 2015 2.104 2004-05-14 09:59:40.000
7 C1 2015 0.214 2004-08-14 12:12:40.000
我要的结果是
ID No Name Price EditTime
2 C1 112-20114 0.652 2004-08-20 11:59:40.000
3 C1 112-20151 0.251 2004-08-12 09:59:40.000
7 C1 2015 0.214 2004-08-14 12:12:40.000
也就是每个相同Name下时间最近的一次记录
问题点数：50、回复次数：3Top
1 楼hisi（海山)(随机种子）回复于 2004-09-01 15:48:26 得分 20
select * from 表 A, ( select max(editTime) as editTime,Name from 表 group by name ) B where A.Name = B.Name and A.EditTime = B.EditTimeTop
2 楼zjcxc（邹建）回复于 2004-09-01 15:49:36 得分 30
select a.* from 表 a, ( select max(editTime) as editTime,Name from 表 group by name ) B where A.Name = B.Name and A.EditTime = B.EditTime
Top
3 楼zjcxc（邹建）回复于 2004-09-01 15:50:44 得分 0
--如果日期最大的会相同:
select a.* from 表 a, (select id=min(id) from 表 a,(select max(editTime) as editTime,Name from 表 group by name ) B where A.Name = B.Name and A.EditTime = B.EditTime group by name) b where a.id=b.id
Top
