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
- 15624 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
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to name query output columns in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Please explain oracle left join with an example?
How do I connect to oracle database?
How do I limit the number of oracle database connections generated by weblogic server?
How to execute a stored procedure in oracle?
What is meant by an index?
What is a data lock in oracle?
Where do you use decode and case statements?
Please explain oracle data types with examples?
interview questions with answer for cts
Explain oracle insert into command?
How oracle handles dead locks?
Explain mutating triggers.
