a query to select maxmun 3 salaries of employee table
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
Explain about achiever in sql?
Explain what are synonyms used for?
Explain oracle data types with examples?
Is truncate autocommit in oracle?
What is translate in oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What are the components of logical database structure in oracle database?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What is an oracle?
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
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to change program global area (pga) in oracle?
Is insert autocommit in oracle?
What is a initialization parameter file in oracle?