Search:

Hi Krishna,

This query fulfills the requirement. Any performance difference from the ones given by others???


Query:
------

SELECT *
FROM TableName

Hi,

you asked for sorting and it can be done using ORDER BY keyword.
ORDER BY <DATE COLUMN>

Bye.

Hi,

The answer provided with LEAD and OVER gives you the difference between only successive employees.

If the question is to get difference between all employees, then its better to use a cross...

Hi,

Say you have this data in a table

ABC:

NO NO1
2a 3b
5a 9b