SQL Comparision

SQL Comparision

 

  

Hi All,
How to compare one row with another row in the whole table by using single query instead of cursor?. Is it possible?, if yes, please give an idea.

Thanks & Regards,

MS Sql Server LazyDBA home page