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

Explain what is a subquery ?

1135

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1021

What are two statement types in sql?

1054

Why is sharding used?

964

What is the function that is used to transfer a pl/sql table log to a database table?

974

What is the usage of distinct keyword?

1032

How many commands are there in sql?

992

Why is pl sql used?

953

Explain alias in sql?

1009

What does fetching a cursor do?

1049

what are set operators in sql? : Sql dba

1000

What is the difference between function and procedure in pl/sql?

1036

Are stored procedures compiled?

888

how to fetch common records from two tables? : Sql dba

1131

what is the difference between truncate and delete statement? : Transact sql

1033