SQL SERVER 查询第20行到30之间的数据

fteair

1.先查询前20行的ID,后查询除去20条记录的前10条记录

1. SELECT TOP 10 * FROM tbBank
   
2. WHERE BankID NOT IN(SELECT TOP 20 BankID FROM tbBank ORDER BY BankID ASC)

复制代码

2.先查询前20行记录最大的ID,后查询大于该值的前10条记录

1. SELECT TOP 10 * FROM tbBank
   
2. WHERE BankID>(SELECT MAX(BankID) FROM (SELECT TOP 20 BankID  FROM tbBank ORDER BY BankID ASC)AS TEMP)

复制代码

3.SQL SERVER 2015 以后使用 ROW_NUMBER() 函数

1. SELECT * FROM (SELECT *,ROW_NUMBER() OVER(ORDER BY BankID ASC) AS Num FROM tbBank )AS TempTable
   
2. WHERE Num BETWEEN 21 AND 30

复制代码

fteair

fteair

fteair

fteair

fteair

fteair

张兴康