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 can we repair a mysql table? : Sql dba

913

How to get unique records from a table?

896

What is clustered index in sql?

999

Is not null in sql?

924

How do you update a table in sql?

921

What are the different types of joins in sql?

1649

Why do we need sharding?

935

What are the benefits of pl sql?

1049

Whis is not false in primary key?

1400

Define implicit and explicit cursors.

1072

Explain autonomous transaction.

1092

What is microsoft t sql?

880

what is the use of double ampersand (&&) in sql queries?

1114

How many scalar data types are supported in pl/sql?

974

is mysql query is case sensitive? : Sql dba

1029