Select salary From ( Select salary from emp order by salary desc) Where r

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

Question Posted / ramesh.p

Answer Posted / ramesh.p

Select salary
From ( Select salary from emp order by salary desc)
Where rownum =2;

Is This Answer Correct ?

10 Yes

19 No

Please Help Members By Posting Answers For Below Questions

how can we destroy the cookie? : Sql dba

961

what is acid property in database? : Sql dba

962

How do you create a db file?

959

What does select count (*) mean in sql?

964

What is the most restrictive isolation level? : Transact sql

1028

How delete all records from table in sql?

930

What is a dynamic query?

973

Which tcp/ip port does sql server run?

958

What is primary key and foreign key?

917

Why are indexes and views important to an organization?

899

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

988

how many sql ddl commands are supported by 'mysql'? : Sql dba

959

What is tuple in sql?

1008

How do I remove all records from a table?

1026

How can you load multi line records? : aql loader

1022