SELECT SAL FROM EMP E WHERE &N-1 =(SELECT COUNT(*) FROM EMP WHERE E.S

find out the third highest salary?

Question Posted / esha gautam

Answer Posted / esha gautam

SELECT SAL FROM EMP E WHERE &N-1 =(SELECT COUNT(*) FROM EMP
WHERE E.SAL<SAL);

HERE N FOR NTH SALARY!!!!!!!!!!!!!!!!!!!!

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Does facebook use oracle?

1029

What is oracle and what are its different editions?

1064

What is a table index?

1093

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

1065

How to define an external table with a text file?

1062

What is proxy method?

971

What is recovery manager in Oracle?

1052

How to check your oracle database 10g xe installation?

984

What are the various oracle database objects?

1142

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

2181

How to do paging with oracle?

995

Does oracle database need java?

1002

How to drop a stored function?

1135

How to create additional tablespaces for an new database?

1022

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

1039