@_@! 结束啦~~
sqlserver--获取同组数据的前两条记录
标签：
sqlserver--获取同组数据的前两条记录
t.* from
(select *,row_number() over(partition by userAccount, submitTime order by submitTime) rn from demoTable) t
where rn <=2