select top 10 * from table where d = 'ii' order by sortcol select top 10 * from table where d = 'ii' order by sortcol desc
--前10条 SELECT * FROM ( SELECT *,ROW_NUMBER() OVER (ORDER BY D ASC ) AS ROWNUMBER FROM 表 ) T WHERE D='II' AND ROWNUMBER BETWEEN 1 AND 10 --后10条 SELECT * FROM ( SELECT *,ROW_NUMBER() OVER (ORDER BY D DESC) AS ROWNUMBER FROM 表 ) T WHERE D='II' AND ROWNUMBER BETWEEN 1 AND 10
select top 10 * from table where d = 'ii' order by sortcol select top 10 * from table where d = 'ii' order by sortcol desc
select top 10 * from T where D='II' order by D select top 10 * from T where D='II' order by D desc
from table
where d = 'ii'
order by sortcol
select top 10 *
from table
where d = 'ii'
order by sortcol desc
SELECT * FROM
(
SELECT *,ROW_NUMBER() OVER (ORDER BY D ASC ) AS ROWNUMBER FROM 表
) T
WHERE D='II'
AND ROWNUMBER BETWEEN 1 AND 10
--后10条
SELECT * FROM
(
SELECT *,ROW_NUMBER() OVER (ORDER BY D DESC) AS ROWNUMBER FROM 表
) T
WHERE D='II'
AND ROWNUMBER BETWEEN 1 AND 10
from table
where d = 'ii'
order by sortcol
select top 10 *
from table
where d = 'ii'
order by sortcol desc
select top 10 * from T where D='II' order by D desc