How to find out second largest value in the table? - oracle

How to find out second largest value in the table?

SELECT * FROM EMP
WHERE SAL IN (SELECT MAX(SAL) FROM EMP
WHERE SAL <> (SELECT MAX(SAL) FROM EMP))
Disadvantage of user defind function in oracle
Disadvantage of user defind function in oracle - Disadvantage of UDF in Oracle: Oracle does not support calling UDFs with Boolean parameters or return types...
Significance of cluster table or non cluster table - oracle
Cluster table or non cluster table - A Cluster provides an alternate method of storing table data. It is made up of a group of tables that share the same data...
What is pragma restrict_reference in oracle 9i?
Pragma restrict_reference - Pragma restrict_reference is used to check for violations of any rules applied, at compile time. It’s used in functions to obey some...
Post your comment

Related Content

Follow us

▲