oracle 获取科目前3名
时间：2021-07-01 10:21:17
帮助过：6人阅读
* 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
oracle 获取科目前3名
标签：desc sele har number code weight select over bsp
