Question

查找每个用户的前10条记录，sql语句怎么写

Answer 1

select * from (

select row_number() 

over(partition by a.用户字段 order by a.表主键 desc) rn,a.用户字段,A.表主键

from 表 a)t where t.rn<=10

order  by 用户字段, rn

Answer 2

select * from (
select row_number()
over(partition by a.xx order by a.xxxx desc) rn,a.xx,A.xxxx
from BIAO a)t where t.rn<10