how to find the count of employee in the following issue

suresh508

hi friends ,

in a table there are so many employees with different ages ..i want the count of the employees greater than the age of that employee....

ex...
empno age
1 35
2 23
3 24
4 27

the output should be

empno age noofpersons

1 35 0
2 23 3
3 24 2
4 27 1

debasisdas

use COUNT() and DECODE() functions .

how to find the count of employee in the following issue

re: how to find the count of employee in the following issue

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about