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

Explain the purpose of %type and %rowtype data types?

974

what is the difference between a having clause and a where clause? : Sql dba

1155

How to run sql commands in sql*plus?

1249

What is a constraint? Tell me about its various levels.

1245

How many sql commands are there?

1158

What is sorting in sql?

983

How to get each name only once from an employee table?

1154

What are synonyms in sql?

1018

What do you understand by pl/sql cursors?

1148

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1223

How many developers work on postgresql?

1040

Why use stored procedures?

1140

How do I access sql anywhere database?

1021

Can we use pl sql in sql server?

1132

What is sql in java?

1134