Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 20197 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answer Posted / raju
select * from emp a where 3>=(select count(distinct(b.sal))
from emp b where b.sal>=a.sal )
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How can I create database in oracle?
How is it different from a normal table?
What is a subquery?
What happens to indexes if you drop a table?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Explain the difference between replace() and translate() functions in oracle?
What are group functions in oracle?
How does the on-delete-cascade statement work?
What types of joins are used in writing subqueries?
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?
Explain drop constraint oracle?
What to do if the startbd.bat failed to start the xe instance?
What is the usage of control file in oracle?
What language does oracle use?
