how to compare rows for a specific column in the same table

• bug

  SSC-Addicted

  Points: 470

  More actions

  January 8, 2006 at 3:11 pm

  #103021

  Hello,

  I have a table contains a column with increment numbers, how can I extract all records with increment less than 2?

  example of the table

  table [t1]

  col

  1

  2

  3

  7

  8

  14

  desired result

  col

  1

  2

  3

  7

  8

   

  Thanks in advance

   

   

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  January 8, 2006 at 3:24 pm

  #613445

  select t1.col

  from table t1

  inner join tabe t2 on t1.col = t2.col - 1

   

  _____________
  Code for TallyGenerator

• bug

  SSC-Addicted

  Points: 470

  More actions

  January 8, 2006 at 5:00 pm

  #613448

  Thanks!