OracleÖÐÕâ¸öÎÊÌâÔõô²éѯ - MS-SQL Server / »ù´¡Àà

½«Éè±íÃû½Ðtest£¬°´ID½µÐòÅÅÁУ¬È»ºó´Ó±íÖÐÕÒ³öµÚ3£¬µÚ4Ìõ¼Ç¼£¨±íÖеļǼ·Ç³£¶à£©¡£

---

select * from tb where rownum between 3 and 4

---

ÒýÓÃ

½«Éè±íÃû½Ðtest£¬°´ID½µÐòÅÅÁУ¬È»ºó´Ó±íÖÐÕÒ³öµÚ3£¬µÚ4Ìõ¼Ç¼£¨±íÖеļǼ·Ç³£¶à£©¡£

--°´ID½µÐòÅÅÁÐ
SQL code:
select * from tb where rownum between 3 and 4 order by id desc

---

ÎÊÏ£¬Ïë²éÇ°5ÌõÊý¾ÝÓÃʲô

---

ÒýÓÃ

ÎÊÏ£¬Ïë²éÇ°5ÌõÊý¾ÝÓÃʲô

select top 5 * from test order by id desc

---

ÒýÓÃ

ÎÊÏ£¬Ïë²éÇ°5ÌõÊý¾ÝÓÃʲô

SQL code:
select top 5 * from tb

---

ÒýÓÃ

ÎÊÏ£¬Ïë²éÇ°5ÌõÊý¾ÝÓÃʲô

SQL code:
select top 5 * from tb order by id desc

---

Ó¦¸ÃÊÇÕâÑù£º
SQL code:

select * from tb where rownum<=5