a query to select maxmun 3 salaries of employee table
Answer Posted / kannan
select * from emp
where sal in (select max(sal) from emp
where level<=3
connect by prior sal>sal
group by level)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What exactly do quotation marks around the table name do?
What to do if dba lost the system password?
What is oracle thin client?
How to change user password in oracle?
How to rebuild an index in oracle?
Give the various rollback segment states.
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How to create a new oracle data file?
How to define an oracle cursor variable?
Explain the use of parfile option in exp command.
How to bring a tablespace online?
How to resolve name conflicts between variables and columns?
What is a cognitive schema?
What happens to the current transaction if the session is ended?
material view and view disadvantages?