find out the third highest salary?
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
What is pragma autonomous transaction in oracle?
How to increment dates by 1 in oracle?
how the indexes are stored in the Oracle Database?
How index is implemented in oracle database?
what is Single Byte Overhead...?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Explain user account with reference to oracle.
how can we store any pdf file in oracle
How to define an explicit cursor in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is the difference between PFILE and SPFILE in Oracle?
What is tns service name?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to generate query output in html format?
What is oracle rowcount?