SQL query

• rajeevs

  Newbie

  Points: 2

  More actions

  May 20, 2003 at 3:26 pm

  #80940

  How can I select fixed number of records from q sql query? Suppose I want to extract row 10 to 20, is there a way?

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  May 20, 2003 at 3:36 pm

  #457908

  Try something like this:

  select name from

  (select top 10 a.name from

  (select top 20 name from sysobjects order by name asc)

  a order by a.name desc)

  b order by b.name asc

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP

• rajeevs

  Newbie

  Points: 2

  More actions

  May 20, 2003 at 9:09 pm

  #457915

  Thank you very much. It worked fine.