°ïÎÒ¿´¿´ÕâSQLÓï¾ä

select top 5 * from [User] where id>(select max(id) from (select top 10 id from [User]) as tabtmp)


±íÖÐÓÐ16ÌõÊý¾Ý£¬ÎÒÒªÏÔʾËûµÚ11-15Ìõ¡£
¶ø²é³öÀ´µÄÈ´Êǿյģ¬ÕÒÁ˺þÃÕÒ²»³ö´íÔÚÄÄ¡£

---

ÄãÈ·¶¨11-15µÄid´óÓÚÇ°Ê®ÌõµÄidÂð

---

idÊDZêʶÁУ¬Ä¬ÈÏûÅÅÐò»áÊÇÉýÐò£¬ËùÒÔ11-15Ìõ¼Ç¼µÄID¿Ï¶¨´óÓÚÇ°10Ìõ

---

¿´²»³öÄÄ´íÁË
Äã·Ö¶ÎÊÔÊÔ
ÏÈselect top 10 id from [User]
ÔÙselect max(id) from (select top 10 id from [User]) as tabtmp
ÔÙselect top 5 * from [User] where id>(select max(id) from (select top 10 id from [User]) as tabtmp)
¿´Ã¿Ò»²½ÊDz»ÊÇÄãÒªµÄ½á¹û

---

SQL code:
select top 5 * from tablename where id not in (select top 10 id from tablename)

---

select v.* from (
select *, row_number() over (order by id) Drcount from [User]) v
where v.Drcount>10 and v.Drcount <16
ÊÔÒ»ÏÂÕâ¸ö¿´

---

ÒýÓÃ

SQL codeselecttop5*from tablenamewhere idnotin (selecttop10 idfrom tablename)

ÕâÑù²»Ðеģ¬ºóÃ滹ÓÐÊý¾ÝÄØ£¬Èç¹ûºóÃ滹Óм¸Ê®WÌõÊý¾ÝÄØ¡£¡£

---

select max(id) from (select top 10 id from [User]) as tabtmp
½á¹ûÊÇʲô£¿

---

ÒýÓÃ

SQL codeselecttop5*from tablenamewhere idnotin (selecttop10 idfrom tablename)

¶¥

---

select top 15 * from tab