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

Answer Posted / hari.sidd

SELECT ENAME
FROM EMPLOYEE
WHERE ESAL=MAX(ESAL);

Is This Answer Correct ?    1 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use in conditions in oracle?

557


Explain joins in oracle?

561


What are the predefined tablespaces in a database?

556


Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1442


What is oracle used for?

536






Explain integrity constraint?

644


Can I create users through internet explorer in oracle 10g?

573


How to pass parameters to procedures in oracle?

570


How to export several tables together?

568


What are the various types of snapshots ?

562


Explain oracle left join with an example?

587


What is a cursor variable?

576


Is oracle a programming language?

567


Can group functions be mixed with non-group selection fields?

536


How can you merge two tables in oracle?

567