select max(sal) from Emp where sal < (select max(sal) from Emp)

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

Question Posted / cooldude

Answer Posted / cooldude

select max(sal) from Emp where sal < (select max(sal) from
Emp)

Is This Answer Correct ?

14 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the reports view in oracle sql developer?

1000

What is oracle and pl sql?

1127

What is difference between sql and oracle?

1142

how can you see all indexes defined for a table? : Sql dba

1008

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

1076

What is the maximum size of sqlite database?

1117

How does left join work in sql?

1012

What does pl sql developer do?

939

what does it mean to have quoted_identifier on? : Sql dba

1153

Is join an inner join?

981

How do you write an inner join query?

964

What is the current version of sql?

1032

Explain two easy sql optimizations.

1024

Can we insert in sql function?

1097

What is the maximum number of rows in sql table?

1037