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

What is the difference between delete and truncate statement in sql?

1064

What is left inner join in sql?

1038

How to write html code in pl sql?

1108

how to enter binary numbers in sql statements? : Sql dba

968

How do you declare a constant?

958

How do I add a primary key to a table?

1040

what is the difference between inner and outer join? Explain with example. : Sql dba

1021

What are different types of functions in sql?

1004

What is group by in sql?

1080

what is an extent ? : Sql dba

1086

What do you mean by query optimization?

996

What is data definition language?

1088

How can one get sql*loader to commit only at the end of the load file? : aql loader

1054

What are properties of the transaction?

996

How many sql are there?

988