SELECT TOP(15) * FROM table1 WHERE.. EXCEPT SELECT TOP(14)* FROM table1 WHERE...
--也可以用ROWNUMBER函数返回行数 ;WITH DD ( SELECT *,ROW_NUMBER()OVER(ORDER BY AGE)NB FROM S ) SELECT * FROM DD WHERE NB=N--指定第N行就行了 --或则 SELECT DD.* FROM (SELECT *,ROW_NUMBER()OVER(ORDER BY AGE)NB FROM S )DD WHERE NB=N--指定第N行
--也可以用ROWNUMBER函数返回行数 ;WITH DD ( SELECT *,ROW_NUMBER()OVER(ORDER BY 排序列)NB FROM table1 ) SELECT * FROM DD WHERE NB=N--指定第N行就行了 --或则 SELECT DD.* FROM ( SELECT *,ROW_NUMBER()OVER(ORDER BY 排序列)NB FROM table1 )DD WHERE NB=N--指定第N行
SELECT TOP(15) * FROM table1 WHERE..
EXCEPT
SELECT TOP(14)* FROM table1 WHERE...
--也可以用ROWNUMBER函数返回行数
;WITH
DD (
SELECT *,ROW_NUMBER()OVER(ORDER BY AGE)NB
FROM S
)
SELECT * FROM DD WHERE NB=N--指定第N行就行了
--或则
SELECT DD.*
FROM (SELECT *,ROW_NUMBER()OVER(ORDER BY AGE)NB
FROM S
)DD
WHERE NB=N--指定第N行
--也可以用ROWNUMBER函数返回行数
;WITH
DD (
SELECT *,ROW_NUMBER()OVER(ORDER BY 排序列)NB
FROM table1
)
SELECT * FROM DD WHERE NB=N--指定第N行就行了
--或则
SELECT DD.*
FROM (
SELECT *,ROW_NUMBER()OVER(ORDER BY 排序列)NB
FROM table1
)DD
WHERE NB=N--指定第N行