Royal Crazy's
To provide Best Solutions for C,Java,Sql,Pl/Sql,Bi Publisher,Oracle apps ...................
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment