Hi Krishna,
This query fulfills the requirement. Any performance difference from the ones given by others???
Query:
------
SELECT *
FROM TableName
Type: Posts; User: indira.s; Keyword(s):
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