select * from emp a where &n=(select count(b.sal) from emp b where b.

find out the third highest salary?

Question Posted / hanumantha r challa

Answer Posted / hanumantha r challa

select * from emp a where &n=(select count(b.sal) from emp
b where b.sal>=a.sal);

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to rename an index?

1071

How to compare dates in oracle sql?

1102

How do we represent comments in oracle?

1046

What are the differences between date and timestamp in oracle?

1044

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1915

Can group functions be used in the order by clause in oracle?

997

What is a package in oracle?

1098

List out the components of logical database structure of oracle database.

1035

How do I manually create a database in oracle?

1019

What are the roles of dba?

1066

query optmization techniques and quwry analyser+projects+ppts

2419

What is save point in oracle database?

1290

How do I uninstall oracle 11g?

1115

How do I connect to oracle database?

1115

What is oracle database client?

1030