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

Answer Posted / atal patra

select ename,max(sal)from emp group by ename;

Is This Answer Correct ?    6 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to start an oracle instance?

567


Is java required for oracle client?

542


what happened to the global index when I truncate the data in one of the partition?

1512


Explain about achiever in sql?

576


How to drop a stored function?

670






How to upsert (update or insert into a table)?

530


What is an oracle database?

605


How many memory layers are in the oracle shared pool?

633


How do you find current date and time in oracle?

578


What is oracle host variable?

531


What do you mean by merge in oracle and how can you merge two tables?

514


How to convert characters to dates in oracle?

557


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1434


How to recover a dropped table in oracle?

599


what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2039