select Name from emp where sal=(select distinct(Max(sal)) from emp

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

Question Posted / mk

Answer Posted / mk

select Name from emp where sal=(select distinct(Max(sal))
from emp

Is This Answer Correct ?

4 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What are the different pseudo commands? Explain in general?

1125

What is the usage of analyze command in oracle?

1141

Explain oracle left join with an example?

1064

How do I call oracle stored procedures that take no parameters?

1206

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2173

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1792

How do I uninstall oracle 11g?

1178

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2423

How to invoke the data pump import utility?

1229

Difference between hot backup vs. Cold backup?

1040

How to lock and unlock a user account in oracle?

1162

How do I spool to a csv formatted file using sqlplus?

1090

How to check your oracle database 10g xe installation?

1053

How can we find out the duplicate values in an oracle table?

1121

What is a proxy class?

1107