how to get second highest salary in SQL(as/4000
Answer Posted / s. syam sundar
1.SELECT LEVEL,MAX(SAL) FROM EMP WHERE LEVEL = 2 CONNECT BY
PRIOR SAL >SAL GROUP BY LEVEL
2.SELECT SAL FROM (SELECT SAL FROM EMP ORDER BY SAL DESC)
WHERE ROWNUM <3
MINUS
SELECT SAL FROM (SELECT SAL FROM EMP ORDER BY SAL DESC)
WHERE ROWNUM = 1
3.SELECT MAX(SAL) FROM EMP WHERE SAL <> (SELECT MAX(SAL)
FROM EMP)
regards
syam sundaar
Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What is the difference between python and sql?
What are the operators used in select statements?
What are sql objects?
How to change the order of columns in Oracle SQL Plus ?
Explain autonomous transaction.
What is offset in sql query?
What is a data manipulation language?
What is primary key sql?
What is the difference between a database and a relational database?
What is range partitioning?
Is sql similar to python?
What is package in pl sql with an examples?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What does select top 1 do in sql?
What is dense_rank?