Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 20355 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
Why should I use oracle database?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Write a trigger example in oracle?
What is a nvl function? How can it be used?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is coalesce function?
How to select all columns of all rows from a table in oracle?
What is a nvl function?
What is connection pooling in oracle?
How to find out what oracle odbc drivers are installed?
How to insert multiple rows with one insert statement in oracle?
How do you store pictures in a database?
Why does oracle 9i treat an empty string as null?
 How to use an oracle sequence generator in a mapping?
Explain the use of rows option in imp command.
