转载自:http://www.itpub.net/thread-1736695-1-1.html
如图
取出黄色标记的数据
解决方法:(在oracle成功)
select t.name1,t.name2,t.zx
from (select row_number()over(partition by name1 order by zx desc)rn, test.* from test)t
where t.rn=1;
用rank的话你zx有值相等的,还是用row_number好了
法:
查询其他的:
sqlServer:类似的情况(未测试)
select * from t1 t where id = (select top 1 id from t1 where id = t.id order by createtime desc)