Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 19851 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answer Posted / suresh babu
select * from employees a where 3 <= select count(distinct
b.salary) from employees b where a.salary >= b.salary);
This query,which returns the first maximum salary from
employees table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to write a query with a right outer join in oracle?
How do I connect to oracle database?
Can we store images in oracle database?
What is a cursor and what are the steps need to be taken?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How to use in conditions in oracle?
What is an Oracle index?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to pass a parameter to a cursor in oracle?
How to create an oracle testing table?
What is define in oracle?
How to create a new table in oracle?
What is a cognitive schema?
How to establish administrator authentication to the server?
ABOUT IDENTITY?
