To find nth salary: SELECT SUBSCRIBER_no FROM (SELECT SUBSCRIBER

find out the third highest salary?

Question Posted / madhu

92 Answers
147701 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

Answer Posted / madhu

To find nth salary:

SELECT SUBSCRIBER_no
FROM (SELECT SUBSCRIBER_NO, ROWNUM R
FROM (SELECT DISTINCT SUBSCRIBER_NO
FROM SUBSCRIBER
ORDER BY SUBSCRIBER_NO DESC))
WHERE R = &R

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to invoke the data pump import utility?

1082

What is a cursor and what are the steps need to be taken?

1118

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1814

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1326

What is the implicit cursor in oracle?

1039

What is index in Oracle?

1014

What is an oracle user account?

932

How do we represent comments in oracle?

1003

How to start an oracle instance?

953

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2220

Is postgres faster than oracle?

972

How to add another datafile to a tablespace?

994

What is BBED in Oracle?

1091

What happens if you set the sga too low in oracle?

1054

Will you be able to store pictures in the database?explain.

931