Re: Need help with SQL group by

What value of plbhrs do you need? If you need the sum...use

SELECT eeun, eedpt, plbemp, eenam, plbbg1, SUM(plbhrs) , plbptp
FROM PRLBH, EEMP WHERE PLBEMP = EEENO and
PLBPTP in('CO','OH', '6D','7D','OG') and
EETDT = 0 and EEDPT = '081' and PLBWDT = 20090115
GROUP BY eeun, eedpt, plbemp, eenam, plbbg1,plbptp
Order by PLBEMP

If you need the maxiumum/minimum value...you can use...

SELECT eeun, eedpt, plbemp, eenam, plbbg1, MAX(plbhrs) , plbptp
FROM PRLBH, EEMP WHERE PLBEMP = EEENO and
PLBPTP in('CO','OH', '6D','7D','OG') and
EETDT = 0 and EEDPT = '081' and PLBWDT = 20090115
GROUP BY eeun, eedpt, plbemp, eenam, plbbg1,plbptp
Order by PLBEMP

--- On Mon, 8/17/09, Smith, Mike <Mike_Smith@xxxxxxxxxxxxxxxx> wrote:


From: Smith, Mike <Mike_Smith@xxxxxxxxxxxxxxxx>
Subject: Need help with SQL group by
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: Monday, August 17, 2009, 3:45 PM


I have a sql statement that I cannot get to work the way I want. 
The statement as it currently exists is.
SELECT eeun, eedpt, plbemp, eenam, plbbg1, plbhrs , plbptp
FROM PRLBH, EEMP WHERE PLBEMP =  EEENO and
PLBPTP in('CO','OH', '6D','7D','OG') and
EETDT = 0 and   EEDPT = '081' and PLBWDT = 20090115
GROUP BY PLBEMP,EENAM,PLBBG1, PLBHRS  , PLBPTP,EEUN, EEDPT 
Order by PLBEMP           

My results look like this
   
Eeun    eedpt    plbemp  eenam        plbbg1   plbhrs   plbptp
Y    081    890    Smith, Mike    081     4.00    OH
Y    081    890    Smith, Mike    081    1.00    OH
Y    081    1160    Mead,Kurt    081    3.50    OH
Y    081    1160    Mead,Kurt    081    1.50    OH

I am trying to get 1 record per employee, but I cannot find the correct
solution. 
What am I missing here?

Mike

       



NOTICE:  This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.