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

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

Question Posted / brajesh kumar

10 Answers
12531 Views
I also Faced
E-Mail Answers

Answer Posted / brajesh kumar

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

Is This Answer Correct ?

5 Yes

25 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the various types of snapshots ?

1027

How to invoke the original export import utilities?

1056

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2321

How to open and close an explicit cursor in oracle?

1052

What is memory advisor in Oracle?

1077

ABOUT IDENTITY?

2053

How to check database size in Oracle?

1189

What are the uses of Database Trigger ?

1713

What does sharding mean?

995

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2355

How to resolve the ORA-39133 error in Oracle?

1109

How to write a query with a left outer join in oracle?

1061

Can sub procedure/function be called recursively?

996

Explain what are the type of synonyms?

1107

Please explain joins in oracle?

1059