Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153771 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
How to open and close an explicit cursor in oracle?
How to delete an existing row from a table in oracle?
What is backup in Oracle?
How will you differentiate between varchar & varchar2?
what is Single Byte Overhead...?
Give the constructs of a package, function or a procedure.
What are the limitations of check constraint?
What happens if variable names collide with table/column names?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Explain the dml?
What is the relation of a user account and a schema?
Compare and contrast between sql and sql server and explain its various functions?
What is data file?
What is analyze command used for?
How to create a new tablespace in oracle?
