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
- 16042 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
How do I start tns listener?
Can we insert data in view oracle?
What are the advantages of oracle 12c?
What are the extensions used by oracle reports?
State the various uses of dbcc command?
How to connect to the server with user account: sys?
How does oracle handle read consistency?
How to define an anonymous procedure with variables?
What are the attributes of the cursor?
how can we store any pdf file in oracle
What is the purpose of save points in oracle database?
How to update values in a table in oracle?
What are the oracle differences between nvl and coalesce
How do you store pictures in a database?
What is ordinary table in oracle?
