這是一個(gè)通用分頁庫產(chǎn)生的代碼，根據(jù)圖片的注釋，如果去掉前面的fundTime排序放到后面是正常，這是為什么呢？
1 回答
慕姐4208626
TA貢獻(xiàn)1852條經(jīng)驗(yàn) 獲得超7個(gè)贊
SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY fundTime desc) as row_number,* FROM( A.userID from yw_user_fundlog A LEFT JOIN yw_user B ON A.userID=B.userID where 1=1 AND (B.name LIKE '%440%' OR B.mobile LIKE'%440%') group by A.userID,convert(varchar(10), fundTime,20))t) tt WHERE tt.row_number between 1 and 10
只要先分組，然后再排序就好了
添加回答
舉報(bào)
0/150
提交
取消