Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 20718 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
What is the difference between count (*), count (expression), count (distinct expression)?
What is a partition in oracle?
What are the ways tablespaces can be managed and how do they differ?
How to list all indexes in your schema?
How to convert dates to characters in oracle?
What happens to the current transaction if a ddl statement is executed?
Can a formula column be obtained through a select statement ?
Explain alias?
What is a select query statement in oracle?
How to find out what oracle odbc drivers are installed?
How to assign a table row to a record variable?
What are the different types of partitions in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
what is meant by magic query
What is the data pump export utility?
