select e.sal from employee where n-1=(Select count(distinct sal) from emp

find out the third highest salary?

Question Posted / nehal

Answer Posted / nehal

select e.sal from employee where n-1=(Select count(distinct
sal) from emp where sal>e.sal)

Put n=3 for the 3rd highest salary.

Is This Answer Correct ?

10 Yes

7 No

Please Help Members By Posting Answers For Below Questions

please explain.. DB architecture ...

2018

What are the predefined tablespaces in a database?

1079

How to use "in" parameter properly?

1065

How to lock and unlock a user account in oracle?

1104

What to do if the binary spfile is wrong for the default instance?

1067

Does facebook use oracle?

1029

Why does for update in oracle 8 cause an ora-01002 error?

1001

What is the parameter mode that can be passed to a procedure?

1042

What is control file used for?

1202

Where are the settings stored for each instance in oracle?

1105

What are the uses of a database trigger?

994

How to connect asp pages to oracle servers?

1072

What is oracle join syntax?

1001

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

2353

How to Truncate Table in Oracle

1154