´ó¼ÒºÃ£¬ÎÒÎʸösqlµÄ - .NET¼¼Êõ / C#

ÓÐ10WÌõÊý¾Ý£¬ÒªÈ¡³ö90000µ½900010Ö®¼ä µÄ10Ìõ¼Ç¼

ЧÂÊ×î¿ìµÄÓï¾äÔõôд£¿£¿

---

select top 10 * from tab where id>=90000 and id<900011

IDÊÇÖ÷¼ü,ËٶȲ»»áÂý ·ñÔò,Ôõôд¶¼ÊÇÂý

---

select top ÿҳÏÔʾµÄ¼Ç¼Êý * from topic where id not in  
 (select top £¨µ±Ç°µÄÒ³Êý-1£©×ÿҳÏÔʾµÄ¼Ç¼Êý id from topic order by id desc)  
 order by id desc  

with temptbl as (  
  SELECT ROW_NUMBER() OVER (ORDER BY id desc)AS Row,  
  ...  
)  
SELECT * from temptbl where Row between @startIndex and @endIndex

---

select top 10 * from tab where id>=90000 and id<900011

---

select * from tab where id BETWEEN 90000 and 900010

---

ÒýÓÃ

select top 10 * from tab where id>=90000 and id<900011

IDÊÇÖ÷¼ü,ËٶȲ»»áÂý ·ñÔò,Ôõôд¶¼ÊÇÂý

up

---

Èç¹ûÓÐÖ÷¼üID£¨´Ó1¿ªÊ¼µÝÔö£©£¬ÓÃ1Â¥µÄ·½·¨
Èç¹ûûÓÐÖ÷¼üID£¬ÄãµÄÊý¾Ý¿âÊÇSQLSERVER2005»ò2008
ÓÃÏÂÃæµÄÓï¾ä

SELECT A.*
from ( SELECT TOP 90010 *,
  ROW_NUMBER() OVER ( ORDER BY ±í.Ö÷¼ü×ֶΠDESC ) AS RowNumber
  from ±í
  WHERE Ìõ¼þ
  ) A
WHERE A.RowNumber BETWEEN 90001 AND 90010
ORDER BY A.RowNumber

---

Èç¹ûÄãÓÐRowNumberµÄ»°£¬µ±È»Ê¹ÓÃËü¡£

---

SQLдµÄÔ½¸´ÔÓÔ½Âý

---

select top 1