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

What is oracle datasource?

996

Explain about functional dependency and its relation with table design?

1022

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2303

What is the quickest way to export a table to a flat file?

976

Differentiate between function and procedure in oracle.

1091

Can we create trigger on materialized view in oracle?

1001

What privilege is needed for a user to create views in oracle?

1060

What is difference between sid and service name in oracle?

969

What is the relation of a user account and a schema in oracle?

1087

How do I learn what codesets are available in oracle?

1047

How to write date and time interval literals in oracle?

1042

How to create an oracle database manually?

1094

What are the attributes that are found in a cursor?

1086

What is the difference between view and materialized view in Oracle?

1164

What is a sub query and what are the different types of subqueries?

1135