Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 19848 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
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 are the different pseudo commands? Explain in general?
Why cursor variables are easier to use than cursors?
List the parts of a database trigger.
How to convert times to characters in oracle?
State the various uses of dbcc command?
How to connect to a remote server?
How to select some rows from a table in oracle?
How do I find my oracle client driver version?
How to save query output to a local file?
What is difference between truncate and delete?
What are a cluster and non-cluster index?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What are named parameters?
How are extents allocated to a segment?
Explain the difference between a procedure and a function?
