Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151550 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / hhh
select * from employee e where 3 = (select
count(distinct(salary)) from employee where e.salary <= salary);
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How can you use check constraints for self referential integrity?
What is bulk collect in oracle?
What is oracle rowcount?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
What is Reduced List of Values?
What is the difference between count (*), count (expression), count (distinct expression)?
What are the differences between char and varchar2 in oracle?
How to start your 10g xe server from command line?
What is the fastest query method to fetch data from the table?
How to define an anonymous procedure without variables?
What do you mean by cdb and pdb in oracle 12c?
What is a lookup table in oracle?
Why should I use oracle database?
What is the best way to do multi-row insert in oracle?
What is pragma autonomous transaction in oracle?
