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