oracle 获取科目前3名

发布时间：2020-12-12 13:40:42 所属栏目：百科来源：网络整理

导读：SELECT * FROM ( SELECT T. * ,ROW_NUMBER() OVER (PARTITION BY T.SUBJECT,T.CHARCODE ORDER BY T.SCORE DESC ) AS RN FROM T_SCORE T) WHERE RN = 3

SELECT * FROM (
      SELECT T.*,ROW_NUMBER() OVER (PARTITION BY T.SUBJECT,T.CHARCODE ORDER BY T.SCORE DESC) AS RN
      FROM T_SCORE T
)
WHERE RN <= 3

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!