sql分页取数据,或者取个别条数据

--1-15条

SELECT TOP 15 * FROM Table EXCEPTSELECT TOP 0 *FROM TABLE 

--30到40条

SELECT * FROM (SELECT TOP 40 * FROM TABLE) tab1WHEREid NOT IN (SELECT TOP 30 id FROM TABLE) 

--3-5条

SELECT * FROM (SELECT TOP 5 * FROM TABLE) tab1 WHERE id NOT IN (SELECT TOP 2 id FROM TABLE)