今天又用到partition语法了

SELECT * FROM (SELECT row_number() OVER (PARTITION BY UID ORDER BY CreateTime DESC) as rownum, * FROM PandaCoinConvert WHERE uid IN(

164226747,
201659925,
205919280,
196973885,
199114702,
179265670


)) t WHERE t.rownum = 1 ORDER BY t.rownum

 

记录一下

帮客服找这些用户最后一笔充值记录信息