select sal from emp a where &n=(select count(sal) from emp b where a.

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

Question Posted / shasi

Answer Posted / shasi

select sal from emp a where &n=(select count(sal) from emp
b where a.sal>=b.sal)
First u enter 1 means 1st highest sal.then enter2 2nd
highest sal

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

When to use inner join and left join?

1019

What is nosql example?

1096

How does left join work in sql?

1040

what are the different index configurations a table can have? : Sql dba

1042

What are its different types of dbms?

1055

Explain correlated query work?

1107

what are the differences between binary and varbinary? : Sql dba

1085

Could you please provide oca (oracle 10g) dumps for my certification ?

5243

Can you call pl/sql package functions from within a fast formula?

1085

What is cte sql?

1053

What is crud stand for?

1048

What is the difference among union, minus and intersect?

1049

What does t sql mean?

1002

Define commit?

1053

What is the use of function "module procedure" in pl/sql?

1237