selecting related data into groups

[iamready]

Dear All,
I have a bunch of entries (numeric) in a database,each row is related to one other row( all the entries in that row differ by +- 0.5 from one other row in the database, somewhat like almost similar values with minor differences ) how do i write a SQL query to identify the related rows and display them in a group, i.e to display the row followed by the related row.

thank you in advance
regards
harsha

 

[PHV]

And what about the ORDER BY clause ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244