compare consecutive rows

Sometimes you may need to compare consecutive rows or compare two rows from same table. Here is how to compare successive rows by comparing each row with previous row.