How to select the name of employee who is getting maximum
sal with out using subquery
Answer Posted / flitchner
select name from (select max(sal) as salary from emp) a,
emp b
where a.salary = b.sal;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Why use resource manager in Oracle?
What are the uses of a database trigger?
How to export several tables together?
Is oracle a programming language?
How to drop an index in oracle?
What are the differences between date and timestamp in oracle?
How to execute the package in oracle?
What is oracle update statement with inner join ?
Explain the use of record length option in exp command.
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to define an anonymous block?
How to view existing locks on the database?
What are the differences between interval year to month and interval day to second?
Design database draw er diagram for a certain scenario ?