SQL的语句问题,选择前10条记录和后10条记录的问题

我有一个表T里面有个字段D我想选   出符合D="II"的前10条记录和后10条记录,我该怎么办啊,请高手们帮个忙 问题点数：20、回复次数：4Top

1 楼happyflystone（无枪的狙击手）回复于 2006-03-20 16:12:12 得分 5

select   top   10   *  
  from   table    
  where   d     =   'ii'  
  order   by   sortcol  
   
   
  select   top   10   *  
  from   table    
  where   d     =   'ii'  
  order   by   sortcol   descTop

2 楼zlp321002（Life Is Good,Let's Shine）回复于 2006-03-20 16:14:06 得分 5

--前10条  
  SELECT   *   FROM    
  (  
  SELECT   *,ROW_NUMBER()   OVER   (ORDER   BY   D   ASC   )   AS   ROWNUMBER   FROM   表  
  )   T  
  WHERE   D='II'  
  AND   ROWNUMBER   BETWEEN   1   AND   10  
  --后10条  
  SELECT   *   FROM    
  (  
  SELECT   *,ROW_NUMBER()   OVER   (ORDER   BY   D   DESC)   AS   ROWNUMBER   FROM   表  
  )   T  
  WHERE   D='II'  
  AND   ROWNUMBER   BETWEEN   1   AND   10  
  Top

3 楼vagabond40（回首笑看来时路）回复于 2006-03-20 16:22:55 得分 5

select   top   10   *  
  from   table    
  where   d     =   'ii'  
  order   by   sortcol  
   
   
  select   top   10   *  
  from   table    
  where   d     =   'ii'  
  order   by   sortcol   desc  
  Top

4 楼aniude（重返荣耀）回复于 2006-03-20 16:39:41 得分 5

select   top   10   *   from   T   where   D='II'   order   by   D    
  select   top   10   *   from   T   where   D='II'   order   by   D   descTop

相关问题

• top
• 记录
• rownumber
• ii
• order
• desc
• table where
• select

• 帖主：afgghepss1
• happyflystone
• zlp321002
• vagabond40
• aniude

• SQL Server类图书