1.SELECT LEVEL,MAX(SAL) FROM EMP WHERE LEVEL = 2 CONNECT BY PRIOR SAL >

how to get second highest salary in SQL(as/4000

Question Posted / s. syam sundar

29 Answers
31145 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

Please Help Members By Posting Answers For Below Questions

What is a native sql query?

971

Why do we use sql constraints? Which constraints we can use while creating database in sql?

971

What port does sql server use?

985

what is “go” in t-sql? : Transact sql

1038

how to return query output in html format? : Sql dba

1019

What are all the different normalization?

976

What are the parts of a basic sql query?

916

Can we delete column in sql?

1020

Is big data nosql?

885

How can you load multi line records? : aql loader

1019

Name the operator which is used in the query for pattern matching?

891

What is clause?

1062

Why do we need sharding?

935

Can we have two clustered index on a table?

964

How to create your own reports in sql developer?

971