Çë½ÌÒ»SQLÓï¾ä

ÃæÊÔµÄʱºòÓöµ½Ò»Ìâ±»ÄÑסÁË£¬Ïò´ó¼ÒÇë½Ì£º
  д³öÒ»ÌõSQLÓï¾ä£ºÈ¡³ö±íAÖеÚ31µ½40Ìõ¼Ç¼£¬±íAÒÔ×Ô¶¯Ôö³¤µÄIDΪÖ÷¼ü£¬ID¿ÉÄܲ»ÊÇÁ¬ÐøµÄ

---

select top 10 from
(
select top 40 * from tb order by id
) m order by id desc

---

SQL code:
select * from (
select top 10 * from (
select top 40 * from tb order by id
) a order by id desc
) b order by id

---

SQL code:
select *,id1=identity(int,1,1) into #tb from tb

select * from #tb where id between 31 and 40

---

SQL code:

select top 10 * from
(select top 40 * from ±í order by id desc) a
order by id

---

SQL code:
È¡nµ½mÐÐ

1.
select top n-m * from tablename where id not in (select top n id from tablename order by id asc/*|desc*/)

2.
select top m * into ÁÙʱ±í(»ò±í±äÁ¿) from tablename order by columnname -- ½«top m±Ê²åÈëµ½ÁÙʱ±í
set rowcount n --ֻȡnÌõ½á¹û
select * from ±í±äÁ¿ order by columnname desc

3.
select top n * from
(select top m * from tablename order by columnname) a
ord