在不知道ID的情况下 用一条语句查询出 倒叙排列 Tid为20110304的第11条至22条的记录 SQL

用SQL 语句 在不知道ID的情况下 用一条语句查询出 倒叙排列 Tid为20110304的第11条至22条的记录 SQL

SQLSERVER:先选出倒叙的前22条记录，前10条记录；然后查询前22条记录中ID不在前10条这个集合的结果：
select * from (select top 22 * from table where tid = '20110304' order by id desc) a
where not exists (select 1 from (select top 10 * from table where tid = '20110304' order by id desc) b where b.id = a.id)
ORACLE与上相同
select * from (select * from table where tid = '20110304' and rownum <= 22 order by id desc) a
where not exists (select 1 from (select * from table where tid = '20110304' and rownum <= 10 order by id desc) b where b.id = a.id)

SQL SERVER 数据库：(本身数据是正序还是倒叙排列的，若是正序排列的) SELECt * FROM (SELECt TOP 11 * FROM (SELECt TOP 22 * FROM Table_Name WHERe TId = '20110304' ORDER BY ID DESC) AS A ORDER BY ID ASC) AS B ORDER BY ID DESC MYSQL数据库： SELECt * FROM Table_name WHERe Tid = '20110304' ORDER BY ID DESC Limit 10,12

select top 5 bookid from 'table_name' by bookid desc

你看看这样行不行？