Need an prgramming advise

• Daniela-267581

  Ten Centuries

  Points: 1059

  More actions

  July 4, 2006 at 1:20 am

  #76543

  Hi,

  I have a solution for my problem, but I would need an advise, if anyone has a better solution.

  I have to retrieve from sql records between the 4th and the 10 th for example. I can't use something like 'where id between 4 and 10' because the data is sorted after some criteria.

  I am thinking to obtain a numbered query , using a function that returns like n=n+1,

  and:

  select X.field1,X.field2 from (select function(n) as number, field1, field2 from table) as X where X.numer between 4 and 10.

  Any better idea?

  thanks

  ---

  Daniela

• Ward Pond

  SSC Eights!

  Points: 999

  More actions

  July 4, 2006 at 11:35 pm

  #647415

  Hi Daniela..

  Check out the new ROW_NUMBER operator.  It should give you just the functionality you're looking for.

  Hope this helps..

  ---

  Take care..

  - Ward Pond
  blogs.technet.com/wardpond

• Daniela-267581

  Ten Centuries

  Points: 1059

  More actions

  July 5, 2006 at 12:49 am

  #647420

  Wow. I knew I was complicating stuffs.

  Very elegant and simple solution.

  Thank you!

  ---

  Daniela