Select emp.*,dense_rank()over(order by sal desc) rn from emp where rn=3;

write a query to find the third maximum salary of a
employee.(table:employ col name:salary)

Question Posted / suresh

Answer Posted / suresh

Select emp.*,dense_rank()over(order by sal desc) rn from emp
where rn=3;

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

how to write customizations in po

1579

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3515

Explain the use of table functions.

2417

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2487

How would you determine what sessions are connected and what resources they are waiting for?

2099

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2368

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2222

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2073

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2285

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2140

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2158

Can we modify approve purchase order?if yes what is navigation?

1975

How many segment are present in Oracle Manufacturing

2286

which one is currently in used software cmpanies.

2127

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1024