sqlè¯å¥å®ç°éåºååºåäºæ¡è®°å½çæ¹æ³ï¼
1ãsql serverä¸çå®ç°
select top 5 * from 表 where
id not in (select top 5 id from 表)
2ãoracleä¸çå®ç°ï¼
SELECT *
FROM (SELECT a.*, ROWNUM rn
FROM torderdetail a)
WHERE rn >= 5 AND rn <= 10
è¿æ¡è¯å¥å³æ¯è¾åºOracleæ¥è¯¢ç¬¬5å°ç¬¬10æ¡çºªå½ï¼è¿éä¹æ以ç¨rownum rnï¼æ¯ærownum转æå®ä¾ï¼å 为rownumæ¬èº«åªè½ç¨ <=çæ¯è¾æ¹å¼ï¼åªæ转æå®åï¼è¿æ ·å°±å¯å >=çæ¯è¾äºã
1ãsql serverä¸çå®ç°
select top 5 * from 表 where
id not in (select top 5 id from 表)
2ãoracleä¸çå®ç°ï¼
SELECT *
FROM (SELECT a.*, ROWNUM rn
FROM torderdetail a)
WHERE rn >= 5 AND rn <= 10
è¿æ¡è¯å¥å³æ¯è¾åºOracleæ¥è¯¢ç¬¬5å°ç¬¬10æ¡çºªå½ï¼è¿éä¹æ以ç¨rownum rnï¼æ¯ærownum转æå®ä¾ï¼å 为rownumæ¬èº«åªè½ç¨ <=çæ¯è¾æ¹å¼ï¼åªæ转æå®åï¼è¿æ ·å°±å¯å >=çæ¯è¾äºã
温馨提示：内容为网友见解，仅供参考
第1个回答 2010-09-05
把排序字段 ID 改为你的 字段名(有两处)，表1 改为你的 表名
SELECT *
FROM (SELECT TOP 5 *
FROM 表1
ORDER BY ID)
ORDER BY ID DESC
SELECT *
FROM (SELECT TOP 5 *
FROM 表1
ORDER BY ID)
ORDER BY ID DESC
第2个回答 推荐于2018-03-08
select * from 表名 where id not in(select ((select count(*) form 表名)-5) id from 表名 order by 降序字段 desc)本回答被提问者和网友采纳
第3个回答 2010-09-05
比如数据表table_a，按字段field_b降序
mysql:
select * from table_a order by field_b desc limit 5;
mssql:
select top 5 * from table_a order by field_b desc;
mysql:
select * from table_a order by field_b desc limit 5;
mssql:
select top 5 * from table_a order by field_b desc;
相似回答
