Interested to Buy Any Domain ? << Click Here >> for more details...
how to get second highest salary in SQL(as/4000
- 29 Answers
- 32970 Views
- iGate, I also Faced
- E-Mail Answers
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
how to write date and time literals? : Sql dba
Can function return multiple values in sql?
Why function is used in sql?
How many types of sql are there?
What is sql*loader and what is it used for? : aql loader
What is the difference between drop and truncate commands?
How to write a query to show the details of a student from students table whose
how do you login to mysql using unix shell? : Sql dba
When are we going to use truncate and delete?
What are inbuilt functions in sql?
What are sql data types?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
what is the difference between cluster and non cluster index? : Sql dba
Where the sql database files are stored?
Can you select everything, but 1 or 2 fields, without writer's cramp?
