📄 sql server2005分页.sql

📁 一个网上书店的源码

💻 SQL

字号:

SELECT *
FROM 
	(SELECT ROW_NUMBER() OVER (ORDER BY UnitPrice,id)
	AS PriceRank,* FROM books)
	AS Rank
WHERE PriceRank BETWEEN 21 AND 30
ORDER BY UnitPrice,id

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -