select name from (select max(sal) as salary from emp) a, emp b where a.s

How to select the name of employee who is getting maximum
sal with out using subquery

Question Posted / flitchner

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

Please Help Members By Posting Answers For Below Questions

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2555

How to start your 10g xe server from command line?

1073

How view is different from a table?

1040

What is difference between truncate and delete?

1042

How to convert characters to numbers in oracle?

1065

What are the differences between number and binary_float in oracle?

1104

What is a named program unit?

1088

Does oracle database need java?

1013

What are data pump export and import modes?

1071

How to write a query with an inner join in oracle?

1042

How to insert multiple rows with one insert statement in oracle?

1091

How to use subqueries with the exists operator in oracle?

1027

How to create id with auto_increment on oracle?

990

What is a lookup table in oracle?

973

Why does oracle 9i treat an empty string as null?

1059