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 are the different schemas objects that can be created using pl/sql?

969

Does truncate remove indexes?

971

What is rollback?

1038

What is delimiter sql?

924

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

906

What are the different ddl commands in sql?

1066

What is auto increment in sql?

1063

What is the difference between a primary key and a clustered index?

934

how to shutdown mysql server? : Sql dba

1030

what is a composite key ? : Sql dba

995

How do you update f as m and m as f from the below table testtable?

1791

What is use of term?

1008

How do I create a sql script?

1052

What are the types of dbms?

922

What is auto increment feature in sql?

1068