Sqlserver 获取每组中的第一条记录

例子

id	grp	data	createtime
1	g1	10	2011-9-1
2	g1	11	2011-9-2
3	g2	111	2011-10-12
4	g2	12	2011-12-20
5	g3	12	2011-12-20

我们要从上面获得的有效数据为：

id	grp	data	createtime
2	g1	11	2011-9-2
4	g2	12	2011-12-20
5	g3	12	2011-12-20

对应的sql:

select * from t1 t where id = (select top 1 id from t1 where grp = t.grp order by createtime desc )