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

What is aggregate function in sql?

1022

Is sql a scripting language?

977

What steps server process has to take to execute an update statement?

965

What is data control language (dcl)?

1117

How do I access sql anywhere database?

954

What are sql ddl commands?

1075

What are the popular database management systems in the it industry?

983

Explain the steps needed to create the scheduled job?

1028

What is a recursive join sql?

1052

What is the purpose of normalization?

1034

Can primary key be changed?

896

what is sql in mysql? : Sql dba

1178

What is restrict in sql?

1094

How to pipe multiline string to isql?

998

What are the most important ddl statements in sql?

1090