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 / shahid parvez

Answer Posted / shahid parvez

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

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Which command is used to call a stored procedure?

1002

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1007

How would you reference column values before and after you have inserted and deleted triggers?

1066

What do we need to check in database testing?

1022

Is join same as left join?

1042

What is the difference between having clause and where clause?

1063

what is a trigger? : Sql dba

1033

Can triggers stop a dml statement from executing on a table?

1102

How can I change database name in sql?

1087

What plvcmt and plvrb does in pl/sql?

1324

How many tables can you join in sql?

958

What is a relationship and what are they?

1154

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1439

Is it possible to create startup or shutdown trigger for on-schema?

1030

What is a crud api?

956