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

How to call a stored function with parameters?

1049

What happens to the current transaction if the session is killed?

991

How to get a create statement for an existing table?

974

How to create an oracle testing table?

1074

How to drop a stored procedure in oracle?

1056

What is an oracle user account?

996

What are the types of partitions in oracle?

1038

What are the differences between primary key and unique key?

1013

Explain the dml?

988

Explain the difference between a procedure and a function? What do you understand by those terms?

1092

How do we get field detail of a table?

1082

What are the arithmetic operations?

1087

what is the difference between data migration and production migration.

2350

What is a nvl function? How can it be used?

1037

Explain a synonym?

1034