SQL 分类汇总 TOP n 语句

来源:互联网 发布:mysql 连接池配置 5.6 编辑:程序博客网 时间:2024/06/10 00:13
SELECT  [字段1], [字段2], ...
FROM (SELECT ROW_NUMBER() OVER(PARTITION BY [分组字段] ORDER BY [排序字段] ASC) [RN], [字段1], [字段2], ...  FROM [表名]) 别名
WHERE [RN] <=n
原创粉丝点击