To find nth salary: SELECT SUBSCRIBER_no FROM (SELECT SUBSCRIBER

find out the third highest salary?

Question Posted / madhu

92 Answers
150733 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

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2497

Point out the difference between user tables and data dictionary?

980

How to select an oracle system id (sid)?

1064

material view and view disadvantages?

1070

What is an oracle database?

1033

What are temporal data types in oracle?

1121

Why do you create or replace procedures rather that drop and recreate.

1003

What is data file?

1101

Explain the use of rows option in exp command.

1088

What is key preserved table?

1017

Where do you use decode and case statements?

990

What is an oracle transaction?

1139

Can we use bind variables in oracle stored procedure?

948

What is a initialization parameter file in oracle?

1035

What are triggers in oracle?

1034