Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 147698 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
What is snapshot is too old? Give and example for better understand.
What is the disadvantage of User defind function?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What is data file?
How do we get field detail of a table?
What is the difference between translate and replace?
How do I uninstall oracle client from windows?
How to bring a tablespace online?
What is object data modeling?
What is oracle thin client?
How do you bind variables in oracle?
What do you understand by a database object? Can you list a few of them?
Name the various constraints used in oracle?
How to define a sub function?
What language does oracle use?
