第1个回答 推荐于2017-10-08
SQL语句为:
select * from A where ID >=31 and ID <= 40
ORACLE语句为:
select * from A where RowNum>=31 and RowNum<=40
ORACLE和SQL都能使用的是
select top 10 * from (select top 40 * from A order by ID) order by ID desc
或者是
select top 10 * from A where ID not in (select ID from top 30 from A)本回答被提问者和网友采纳
第2个回答 2012-09-07
sql:
select top 10 * from (select top 40 * from A order by A.ID)T
order by T.ID desc
orcal:
SELECT * FROM (SELECT ROW_.*, ROWNUM ROWNUM_ FROM (
SELECT * FROM A
)ROW_ WHERE ROWNUM <=40) WHERE ROWNUM_ > 31
望采纳
第3个回答 2012-09-07
不好意思之前算错数,下面一句SQL代码返回第31到第40共10条记录,按自动ID升序排序:
SELECT T2.* FROM (SELECT TOP 10 T1.* FROM (SELECT TOP 40 * FROM TABLE1 ORDER BY ID)T1 ORDER BY T1.ID DESC) T2 ORDER BY T2.ID
第4个回答 2012-09-07
SELECT TOP 10 * FROM 表名 WHERE ID NOT IN(SELECT ID FROM TOP 30 FROM 表名)
肯定可以用。。