?

例子

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

对应的sql:

?

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