a query to select maxmun 3 salaries of employee table
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 a package in oracle?
What operating systems are supported by oracle database 10g xe?
How to view all columns in an existing table?
What is enter substitution variable in oracle?
Explain the use of indexes option in exp command.
What is a user role in oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is the difference between hot backup and cold backup in oracle?
How to bring a tablespace offline?
How can we delete duplicate rows in a table?
What are the attributes of the cursor?
How would you go about verifying the network name that the local_listener is currently using?
What is the difference between a user and a schema in oracle?
How to connect to a local oracle 10g xe server?
What are the oracle built-in data types?