Select Top 1 sal from (select distinct top 3 sal from emp order by sal des

find out the third highest salary?

Question Posted / abhay

Answer Posted / abhay

Select Top 1 sal from (select distinct top 3 sal from emp
order by sal desc)a order by sal

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a trigger and what are its types in oracle?

1072

20. Using a set operator, display the client number of all clients who have never placed an order.

2187

State the various uses of dbcc command?

1060

How to rename an existing table?

1129

Â What are the oracle DML commands possible through an update strategy?

1063

Can we create database in oracle using command line ?

1085

What are the common oracle dba tasks?

1147

What is a dynamic performance view in oracle?

991

How to define an anonymous block?

1157

When system tablespace is created?

1041

How to select some columns from a table in oracle?

1093

What is background process in Oracle?

1101

What is control file used for?

1209

Where do we use decode and case statements?

1012

What is the difference between sharding and replication?

1048