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

What is the relationship among database, tablespace and data file?

929

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2190

Explain database link?

1062

How to drop an index in oracle?

1022

Can we convert a date to char in oracle and if so, what would be the syntax?

960

How to list all tables in your schema?

992

What is concurrency in oracle?

949

What are temporal data types in oracle?

1066

How to display row numbers with the records?

1025

What are the benefits of ordbms?

1024

How to enter a new row into a table interactively?

963

How to connect ms access to oracle servers?

947

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2332

what is IDE,DMV in sql server?

2754

How do I manually uninstall oracle client?

1025