How to select the name of employee who is getting maximum
sal with out using subquery
- 15 Answers
- 12105 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 to do if the binary spfile is wrong for the default instance?
What is the difference between substr and instr?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is dynamic proxy?
How to sort the query output in oracle?
What is bulk collect in oracle?
What is the relation of a user account and a schema?
What is hot backup and logical backup?
How to filter out duplications in the returning rows using oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
Name the three major set of files on disk that compose a database in Oracle?
What are the varoius components of physical database structure of oracle database?
What is ceil and floor in oracle?
Explain oracle instance.
What is set operator oracle?
