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

What are character functions in sql?

921

What is column?

975

Why do we use triggers?

955

How do I count rows in sql query?

974

What are the various restrictions imposed on view in terms of dml?

957

explain access control lists. : Sql dba

981

What is microsoft t sql?

926

What is trigger and how to use it in sql?

1007

What are the disadvantages of not performing database normalization?

1145

Which command is used to delete a trigger?

1307

What is sql stand for?

970

Which type of cursor is used to execute the dml statement?

941

Explain 3 basic parts of a trigger.

1299

Can I create table without primary key?

982

How do you explain an index?

1267