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
what is a Nested Loop join?
What are the advantages of oracle 12c?
What are the varoius components of physical database structure of oracle database?
Can we store pictures in the database and if so, how it can be done?
what is port in oracle? how is it related to database application.
What is oracle database client?
What is a package in oracle?
Explain the difference between sql and oracle?
How can we force the database to use the user specified rollback segment?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is hash cluster in oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Explain what are the advantages of views?
How to load a large xml file?
Explain an exception?