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 is procedure in pl sql?

980

How many joins in sql?

948

Which is better cte or subquery?

970

Is grant a ddl statement?

856

Can you have more than one key in a database?

893

How do I add a primary key to a table?

973

Does group by remove duplicates?

983

What is sql constant?

945

What is t-sql? : Transact sql

928

What is a left inner join?

948

What are different types of functions in sql?

959

What is a subquery in sql?

977

How does a self join work?

994

what is a stored procedure? : Sql dba

1055

What are different types of indexes?

960