Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153768 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / nehal
select e.sal from employee where n-1=(Select count(distinct
sal) from emp where sal>e.sal)
Put n=3 for the 3rd highest salary.
| Is This Answer Correct ? | 10 Yes | 7 No |
Post New Answer View All Answers
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Difference between hot backup vs. Cold backup?
What is tns name?
How would you begin to troubleshoot an ORA-3113 error?
Explain the characteristics of oracle dba?
Explain oracle data types with examples?
How to revoke create session privilege from a user in oracle?
What is enter substitution variable in oracle?
What is an oracle cursor variable?
Explain the features of oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Can multiple cursors being opened at the same time?
Explain the blob datatype?
What is ceil and floor in oracle?
What is using clause and give example?
