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

Which are the five query types available in oracle?

1001

What is bulk copy or bcp in oracle?

1185

Explain the use of ignore option in imp command.

1087

How to select some columns from a table in oracle?

1175

What is a trigger and what are its types?

1330

What is a tns service name?

1058

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

2479

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4235

When do you get a .pll extension in oracle? Explain its importance

1100

In which language oracle has been developed?

1137

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1098

Explain the use of analyse option in exp command.

1199

What are the general rules on data consistency?

1062

What is the fastest query method to fetch data from the table?

1418

Explain an integrity constrains?

1193