Wednesday, April 16, 2014

Displaying number of records without using count function

SQL> SELECT MAX(SAL) FROM (SELECT ROW_NUMBER() OVER(ORDER BY SAL DESC) SAL FROM EMP) EMPCOUNT;

MAX(SAL)
--------
      14

Note: You can use any column name of your table

No comments:

Post a Comment