Interested to Buy Any Domain ? << Click Here >> for more details...
How to select the name of employee who is getting maximum
sal with out using subquery
- 15 Answers
- 15442 Views
- I also Faced
- E-Mail Answers
Answer Posted / naidu
SELECT * FROM Emp
WHERE LEVEL=&Number
CONNECT BY PRIOR Sal > Sal ;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
State any two functions of oracle?
if you ctreate table identity
How to add a new column to an existing table with a default value?
How to use subqueries with the exists operator in oracle?
How is it different from a normal table?
What is a initialization parameter file in oracle?
master table and child table performances and comparisons in Oracle ?
What is rich query?
What do you mean by a deadlock?
How to create id with auto_increment on oracle?
How to invoke the data pump export utility?
When system tablespace is created?
What is bulk load in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Difference between open_form and call_form in oracle.
