IBM Mainframe Forum

by **nm992** » Mon Sep 06, 2010 12:49 pm

I have 2 tables..

table 1:

Eno Ename Esalary Edept with Eno as Primary Key

Table 2:
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?

by **GuyC** » Mon Sep 06, 2010 3:28 pm

Select all

select * from
Tab2 M join Tab1 E on M.mandept = e.edept
where e.Esal = (select max(a.Esal) from tab1 A where A.edept = e.edept)

IBM Mainframe Forum

Db2 Query

Db2 Query

Re: Db2 Query