九点一刻

摘要： sql语句如下 ;WITH t AS ( SELECT *, ROW_NUMBER() over(partition by userid order by userid) as rownum FROM tableName ) SELECT * FROM t WHERE t.rownum<@count语句中通过partitionby userid order by userid对查询的信息进行分组后，再通过rownum<@count来实现取分组后各项的top @count 阅读全文