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
- 15883 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 is it different from a normal table?
How to create id with auto_increment on oracle?
How to convert raw data type into text in oracle? Explain
How to create a new table in oracle?
What is different types of joins?
What are the limitations oracle database 10g xe?
Give the constructs of a package, function or a procedure.
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
defination of bitmap index
How do I start tns listener?
How to change user password in oracle?
What are the extensions used by oracle reports?
What is meant by joins?
What is the use of aggregate functions in oracle?
How to create a new oracle data file?
