Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 19840 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answer Posted / munna
select * from emp e where &n=(select count(distinct sal)
from emp ee where e.sal<=ee.sal);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Explain the difference between a procedure and a function? What do you understand by those terms?
Explain the truncate in oracle?
How do I learn what codesets are available in oracle?
How many types of synonyms in Oracle?
Explain the blob datatype?
What are the benefits of ordbms?
What is user managed backup in Oracle?
Is the After report trigger fired if the report execution fails ?
Explain integrity constraints?
How to empty your oracle recycle bin?
What is the difference between view and materialized view in Oracle?
Explain the use of analyse option in exp command.
What are the execution control statements?
What is literal?
