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
- 15434 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 manually uninstall oracle client?
How do we get field detail of a table?
Explain the use of inctype option in exp command.
How to empty your oracle recycle bin?
How to start instance with a minimal initialization parameter file?
How to use subqueries in the from clause in oracle?
What is oracle rownum?
How to connect ms access to oracle servers?
Does oracle charge for java?
What is integrity and what is constraint??Explain with example
What is meant by joins? List out the types of joins.
Give the advantages and disadvantages of clusters.
Explain oracle left join with an example?
List the various oracle database objects?
What's dateware house and what's clustor with practicle example
