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

Why is oracle so popular?

971

Give the various rollback segment states.

1031

Use of an integrity constraint is better to validate data. Explain

1023

Why we use bulk collect in oracle?

1013

Explain the use of show option in imp command.

1085

How do I know if oracle is installed on windows?

908

What are transaction isolation levels supported by oracle?

1046

When system tablespace is created?

1016

What are a query and state the different types of queries and their uses?

998

How many types of auditing in Oracle?

1020

various types of hints and their usage

2669

What is the usage of synonyms?

1117

How to create a server parameter file?

1117

How remove data files before opening a database?

1048

Can sub procedure/function be called recursively?

982