select distinct sal from Employee e1 where 3 = (select count(distinct

find the second highest salary of the emp table

Question Posted / chiru

Answer Posted / chiru

select distinct sal
from Employee e1
where 3 = (select count(distinct sal) from Employee e2
where e2.sal >= e1.sal)
order by sal desc

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between translate and replace?

1048

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2030

How to delete a column in an existing table in oracle?

1050

What is the data pump import utility?

1017

How to get execution statistics reports on query statements?

1064

What are the uses of linked server and explain it in detail?

1043

How to connect ms access to oracle servers?

981

How to assign a table row to a record variable?

1010

what is the scenario where you take the database to NoArchivelog mode?

2305

Explain the difference between replace() and translate() functions in oracle?

1021

What is background process in Oracle?

1084

how can we store any pdf file in oracle

2148

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1327

Is oracle the best database?

951

How to find out what oracle odbc drivers are installed?

1024