例如我要查询书籍表中前200名的点击排行榜,我要知道书籍的排名是多少时就要用到
T-SQL代码为:
select top 200 ROW_NUMBER() OVER(ORDER BY Clicked DESC) AS ranking,* from Books
order by Clicked DESC
截图如下:
例如我要查询书籍表中前200名的点击排行榜,我要知道书籍的排名是多少时就要用到
T-SQL代码为:
select top 200 ROW_NUMBER() OVER(ORDER BY Clicked DESC) AS ranking,* from Books
order by Clicked DESC
截图如下: