a query to select maxmun 3 salaries of employee table
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
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is literal?
Explain the use of compress option in exp command.
How many types of database triggers exist?
How to count groups returned with the group by clause in oracle?
how to clone 9i Database on to 10g Database.
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What are advantages of dateset in datastage?
Is it possible to insert comments into sql statements return in the data model editor ?
What do database buffers contain?
How to pass a parameter to a cursor in oracle?
What is the difference between formal parameters and actual parameters?
What happens if you use a wrong connect identifier?
How to drop a stored function?
How to create a new view in oracle?