I have 2 tables..
Eno Ename Esalary Edept with Eno as Primary Key
ManagrID Managersal Mandept with each dept being unique
Note: Each dept is asscoiated with a singlt manager.
Now I want table 3 as:
Manager ID Ename (who is withdrawing Maximum salary for a particular dept).
Can someone please help me with the query?