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

What is bind variable in oracle 11g?

1097

Explain an exception?

1065

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

1418

What is the quickest way to fetch the data from a table?

1100

How to create a new view in oracle?

1129

How would you go about verifying the network name that the local_listener is currently using?

2109

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1959

What is a partition in oracle?

1207

What is a oracle database?

1111

How to drop a stored procedure in oracle?

1106

What is oracle server autotrace in oracle?

1224

What is an oracle cursor variable?

1133

Describe the types of sub query?

1058

How do we get field detail of a table?

1125

Give syntax for SQL and ORACLE joins.

1146