SQL qn:- comparing data in rows

Posted by rayhan on Stack Overflow See other posts from Stack Overflow or by rayhan
Published on 2009-09-25T03:15:46Z Indexed on 2010/06/03 5:04 UTC
Read the original article Hit count: 232

Filed under:
|
|

hi,

i would like to compare numeric data in rows. for eg, i have a table that has a column as such:-

Number
======
 1.88
 9.99
 8.76
 9.88

I want to compare 2nd value, 3rd value, 4th value to the 1st value. And then 3rd, 4th value to the 2nd. then 4th to 3rd.

How can i construct an sql to do this?

© Stack Overflow or respective owner

Related posts about sql

Related posts about data