SQL分组排序去重复

 

 

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

 

==========================

  PARTITION BY userid, classid 这里是按什么分组， 注意一下。

转载于:https://www.cnblogs.com/jiayue360/p/3166876.html