Code666 (代码贴、代码片段)

[SQL] sql server2008的row_number()简单范例 →→→→→进入此内容的聊天室

来自 , 2021-03-03, 写在 SQL, 查看 123 次.
URL http://www.code666.cn/view/d073bb8d
  1. SELECT id,title,ROW_NUMBER() OVER(ORDER BY id DESC) AS ROW
  2. FROM articles
  3. WHERE ROW BETWEEN 5 AND 10
  4. --取表articles按照id倒序排列后的第5-10条记录
  5.  

回复 "sql server2008的row_number()简单范例"

这儿你可以回复上面这条便签

captcha

贴代码片段 - Code666