Sql分组排序取第一条

比如查询用户某一天最后一笔交易后的账户余额

SELECT * from(

SELECT

*, row_number () OVER (

partition BY username

ORDER BY

tradeTime DESC

) rowid

FROM

table

WHERE

tradeDate = '2017-08-31'

) t

 

WHERE

rowid = 1;