-
夜雨离风
发布于 2013-07-02 14:58
-
收藏
复制代码 代码如下:SELECT *FROM ( SELECT userid, classid, remark, ROW_NUMBER () OVER ( PARTITION BY userid, classid ORDER BY addtime DESC ) AS row_bank FROM Eng24VIPCourseIntention ) AS taWHERE row_bank = 1=========================..