SELECT *FROM EMP WHERE SAL=(SELECT MAX(SAL) FROM EMP)

how to find the n'th highest salary from emp ?

Question Posted / brajesh kumar

Answer Posted / brajesh kumar

Is This Answer Correct ?

5 Yes

25 No

Please Help Members By Posting Answers For Below Questions

Explain what are the advantages of views?

1069

What are the most common interview questions on ETL Testing for experience?

1144

Explain oracle’s system global area (sga).

1139

How to write numeric literals in oracle?

1185

How to fetch the row which has the max value for a column?

1002

Respected sir, Please send me technical questions related to oracle apps..

1813

How to set up autotrace for a user account?

1059

How to count duplicated values in a column in oracle?

1044

What is hot backup and logical backup?

1051

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1884

How to change program global area (pga) in oracle?

1095

What do you mean by redo log file mirroring?

1032

How to get the Installed Oracle Version Information ?

1125

How to assign values to data fields in record variables?

1035

What is the best way to do multi-row insert in oracle?

1067