Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 20201 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 substr and instr?
Explain about integrity constraint?
How to create an oracle database manually?
What are a collation and state the different types of collation sensitivity?
How would you change old and new values in an insert, delete and update triggers?
How to create tables for odbc connection testing?
Can group functions be mixed with non-group selection fields?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to shutdown your 10g xe server?
How to define a specific record type?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Explain what are the characteristics of data files?
how to join query for one source type is oracle another source type is sql server ?
What are the restrictions in a oracle read only transaction?
How to open a cursor variable?
