SQL分组排序去重复小实例
2013-07-05 14:49 来源: 站长圈 点击:
SELECT
*
FROM
(
SELECT
userid,
classid,
remark,
ROW_NUMBER () OVER (
PARTITION BY userid,
classid
ORDER BY
addtime DESC
) AS row_bank
FROM
Eng24VIPCourseIntention
) AS ta
WHERE
row_bank = 1
