SQL·ÖÒ³

SQL·ÖÒ³
ÍòÄÜ·ÖÒ³
.net´úÂë
select top Ã¿Ò³ÏÔʾµÄ¼Ç¼Êý * from topic where id not in     
 (select top £¨µ±Ç°µÄÒ³Êý-1£©×ÿҳÏÔʾµÄ¼Ç¼Êý id from topic order by id desc)      
 order by id desc    
select top ÿҳÏÔʾµÄ¼Ç¼Êý * from topic where id not in
(select top £¨µ±Ç°µÄÒ³Êý-1£©×ÿҳÏÔʾµÄ¼Ç¼Êý id from topic order by id desc)
order by id desc
sql2005·ÖÒ³
.net´úÂë
with temptbl as (      
  SELECT ROW_NUMBER() OVER (ORDER BY id desc)AS Row,       
  ...      
)      
SELECT * from temptbl where Row between @startIndex and @endIndex    

.net´úÂë
select top Ã¿Ò³ÏÔʾµÄ¼Ç¼Êý * from topic where id not in     
 (select top £¨µ±Ç°µÄÒ³Êý-1£©×ÿҳÏÔʾµÄ¼Ç¼Êý id from topic order by id desc)      
 order by id desc    
select top ÿҳÏÔʾµÄ¼Ç¼Êý * from topic where id not in
(select top £¨µ±Ç°µÄÒ³Êý-1£©×ÿҳÏÔʾµÄ¼Ç¼Êý id from topic order by id desc)
order by id desc
sql2005·ÖÒ³
.net´úÂë
with temptbl as (      
  SELECT ROW_NUMBER() OVER (ORDER BY id desc)AS Row,       
  ...      
)      
SELECT * from temptbl where Row between @startIndex and @endIndex