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
- 15667 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 to shutdown your 10g xe server?
What privilege is needed for a user to create indexes in oracle?
Explain an exception?
Please explain joins in oracle?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What are privileges and grants?
what is Single Byte Overhead...?
How to start instance with a minimal initialization parameter file?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What does sharding mean?
Is there an oracle sql query that aggregates multiple rows into one row?
What is program global area (pga) in oracle?
State and explain about oracle instance?
Explain about integrity constraint?
How to delete an existing row from a table in oracle?
