select min(sal) from (select distinct sal from emp order by desc where ro

Write a query to find second highest salary of an employee.

Question Posted / preetir

Answer Posted / preetir

select min(sal) from (select distinct sal from emp order by
desc where rownum < 2)

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How is pl sql different from sql?

1142

what is the different between now() and current_date()? : Sql dba

1075

Is sql between inclusive?

1199

How to raise user-defined exception with custom sqlerrm ?

1179

How to Declare Fixed Length String Value In PL SQL

1207

what are integrity rules?

1092

In what condition is it good to disable a trigger?

1070

what is a constraint? : Sql dba

1233

What is a database? Explain

1177

How can get second highest salary in sql?

1026

what are myisam tables? : Sql dba

1077

What is the difference between cross join and natural join?

1066

What is the use of primary key?

1049

What is hibernate and its relation to sql?

1171

What is the cause of mutating table error and how can we solve it?

1099