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 do you mean by table in sql?

999

Explain the difference between sql and mysql.

1068

what is the difference between sql and t-sql? : Transact sql

1100

Can I join the same table twice?

1056

What is sql in java?

1096

Why functions are used in sql?

999

Differentiate between sga and pga.

1170

What is the difference between an inner join and an outer join?

1033

How many sql statements are used?

1020

What are the different types of a subquery?

1056

What is sql and db2?

1013

How to raise user-defined exception with custom sqlerrm ?

1139

How does one load ebcdic data? : aql loader

1185

What is faster join or subquery?

1019

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1006