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
How to start an oracle instance?
Is java required for oracle client?
what happened to the global index when I truncate the data in one of the partition?
Explain about achiever in sql?
How to drop a stored function?
How to upsert (update or insert into a table)?
What is an oracle database?
How many memory layers are in the oracle shared pool?
How do you find current date and time in oracle?
What is oracle host variable?
What do you mean by merge in oracle and how can you merge two tables?
How to convert characters to dates in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to recover a dropped table in oracle?
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 ?