Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151537 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
Why does Oracle not permit the use of PCTUSED with indexes?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
defination of bitmap index
How does one get the view definition of fixed views/tables?
How to drop a stored function?
Explain implicit cursor.
How to delete a user account in oracle?
How to select some columns from a table in oracle?
Explain the characteristics of oracle dba?
definition of cluster and non-clustered index?
Explain the use of control file?
What is the difference between sharding and replication?
What is different types of joins?
How to see the table columns used in an index?
What is oracle join syntax?
