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 AUTH_ID and AUTH_USER in pl/sql ?

2193

is mysql query is case sensitive? : Sql dba

1103

What is t-sql? : Transact sql

988

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1101

how many ways we can we find the current date using mysql? : Sql dba

1099

How to find 3rd highest salary of an employee from the employee table in sql?

1083

Can we use threading in pl/sql?

1041

What is pl/sql language case sensitive?

1127

What is the difference between cross join and natural join?

1022

How to pronounce postgresql?

1059

What are procedures used for?

985

How do you clear the screen in sql?

1069

Explain the uses of control file.

1050

What is an escape character in sql?

1027

What is oracle sql called?

923