Select * from emptable e1 where(N=(select count(DISTINCT(e2.empsal))from

find out the third highest salary?

Question Posted / shashi kumar

Answer Posted / shashi kumar

Select * from emptable e1 where(N=(select
count(DISTINCT(e2.empsal))from emptable e2 where
e2.empsal>=e1.empsal))

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I limit the number of oracle database connections generated by weblogic server?

1070

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.

1349

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2353

What happens if you set the sga too low in oracle?

1143

Explain an extent?

1097

What is oracle and what are its different editions?

1064

What are the restrictions in a oracle read only transaction?

1030

Name the various constraints used in oracle?

1018

What is a nvl function? How can it be used?

1029

Why do you create or replace procedures rather that drop and recreate.

1003

What is a trace file and how is it created in oracle?

1055

What do you mean by a deadlock?

1061

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

2327

What do you understand by a database object? Can you list a few of them?

1016

Difference between inner join vs where ?

1033