我这个翻页sql如何用查询出来的结果进行排序？怎么提示列名无效呢？

[zhiweixuexi8]

SELECT
ROW_NUMBER() OVER(order by L1 desc,L2 desc) AS num,
L3,L4,
(select COUNT(ID) from T1 where ID=@ID) as L1,
(select count(ID) from T2 where ID=@ID) as L2
from Table
ORDER BY num
OFFSET (@YeShu-1)*@Shu ROWS
FETCH NEXT @Shu ROWS ONLY

提示第2行的L1,L2列名无效，请问应该怎么样写呢？

[zhiweixuexi6]

搞定了。。把上面的排序弄到下面就可以了。。