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
What is a select query statement in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is the fastest query method to fetch data from the table?
What is partitioned table in Oracle?
What are the database administrators utilities available?
Why is oracle database so popular?
How to put more than 1000 values into an oracle in clause?
How to drop a stored function?
How to define a record variable to store a table row?
What is an oracle cursor variable?
State and explain about oracle instance?
Is there a combination of "like" and "in" in sql?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to do a full database export?
What is the difference between formal parameters and actual parameters?