select * from (select salary from employees order by salary desc)where ro

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

Question Posted / sachin bhalsinge

Answer Posted / sachin bhalsinge

select * from (select salary from employees order by salary
desc)where rownum=2;

Is This Answer Correct ?

5 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What is pl sql quora?

1231

What is vector point function?

1095

What are few of the schema objects that are created using PL/SQL?

1081

What are pl/sql packages?

1158

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1064

Can a foreign key be null?

1144

What is procedure explain with example?

1008

What type of database is sql?

1067

Can we enter data in a table in design view?

1013

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

1126

what happens if you no create privilege in a database? : Sql dba

1048

What are the different datatypes available in PL/SQL?

1147

Can procedure in package be overloaded?

1141

What is the source code of a program?

1120

Explain how exception handling is done in advance pl/sql?

1046