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 to turn on or off recycle bin for the instance?

1012

What is the meaning of recursive hints in oracle?

995

How to connect to oracle using service name instead of sid?

964

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1010

What are a cluster and non-cluster index?

958

What is primefaces used for?

1009

How to convert characters to dates in oracle?

1026

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2130

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1811

What is set verify off in oracle?

1034

What do you understand by a database object?

990

How to insert a record into a table?

1022

Explain the difference between sap and oracle?

975

What are the different types of synonyms?

1078

Can you tell me how to add new column in existing views?how?How is possible?

1372