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 to fetch values from testtable1 that are not in testtable2 without using not keyword?

1223

Is not null in sql?

997

What is a natural join sql?

977

What are the benefits of stored procedures?

1074

What is the main reason behind using an index?

1018

What is transaction control language (tcl)?

1139

Is left join and outer join same?

1070

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1000

What is sql*plus?

1083

What is difference between mysql and postgresql?

1156

How does join work in sql?

1012

How to check if a column is nullable before setting to nullable?

1128

What is function and procedure in pl sql?

1046

Can we join 3 tables in sql?

1044

what are the security recommendations while using mysql? : Sql dba

1119