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

How do I pipe the output of one isql to another?

1058

which tcp/ip port does sql server run on? : Sql dba

1083

Explain exception handling in pl/sql?

1082

what is a foreign key ? : Sql dba

1114

Sql technical questions

1334

what are null values? : Sql dba

1014

What is trigger in sql?

1156

Is progress software supports to ( pl/sql )?

1098

Can we use the cursor's to create the collection in PL/SQL?

1092

What is a sql select statement?

1082

How to start oracle sql developer?

1074

What is dml and ddl?

1009

How do I view a view in sql?

993

What is forward declaration in pl sql?

1141

Is sql a dbms?

1061