Interested to Buy Any Domain ? << Click Here >> for more details...
How to select the name of employee who is getting maximum
sal with out using subquery
- 15 Answers
- 16457 Views
- I also Faced
- E-Mail Answers
Answer Posted / naresh
Here is the solution.
Select E_id, E_name,Salary from the Employes group by E_ID
Having Salary=Max(Salary)
Should work.
Try it and let me know.
Cheers!
Naresh
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is a Nested Loop join?
How to run the anonymous block again?
How to omit columns with default values in insert statement in oracle?
What are the most common interview questions on ETL Testing for experience?
What happens if you use a wrong connect identifier?
How do you bind variables in oracle?
What are the arithmetic operations?
How can we force the database to use the user specified rollback segment?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What is a nvl function? How can it be used?
What is a cognitive schema?
What is null value in oracle?
How to create a table interactively?
How to write date and time interval literals in oracle?
What are the oracle built-in data types?
