SELECT MAX (sal) FROM emp a, (SELECT MAX (sal) max

Write a query to find second highest salary of an employee.

Question Posted / deepshikha

Answer Posted / deepshikha

SELECT MAX (sal)
FROM emp a,
(SELECT MAX (sal) max_sal
FROM emp) abc
WHERE a.sal < abc.max_sal
ORDER BY sal DESC;

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How many types of cursors are available in pl/sql?

1081

What is a field in a database?

1047

What is localdb mssqllocaldb?

1052

What is the need of a partition key?

969

What is data type in database?

970

what are the disadvantages of mysql? : Sql dba

1129

What are functions in sql?

935

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1144

What schema means?

874

What does := mean in pl sql?

1025

Can a view be mutating? If yes, then how?

1004

How do sql databases work?

979

How many developers work on postgresql?

953

How to test for null values?

1020

What are aggregate functions in sql?

1136