Select Top 1 Sal from (Select Top 3 Sal from emporder by Sal desc) x ord

find out the third highest salary?

Question Posted / chinmaya

Answer Posted / chinmaya

Select Top 1 Sal from (Select Top 3 Sal from emporder by
Sal desc) x order by Sal

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How does Oracle guarantee data integrity of data changes?

2392

What is object data modeling?

970

How to convert raw data type into text in oracle? Explain

993

How data locks are respected in oracle?

1072

Explain database link?

1127

how to join query for one source type is oracle another source type is sql server ?

2428

How index is implemented in oracle database?

1006

What is the recommended interval at which to run statspack snapshots, and why?

2921

How does oracle handle read consistency?

1099

What are the predefined tablespaces in a database?

1085

How to write date and time literals in oracle?

1002

What happens to the current transaction if the session is killed?

990

what is Single Byte Overhead...?

2559

query optmization techniques and quwry analyser+projects+ppts

2422

What are internal user account in oracle?

1011