RE: Need help with SQL group by

["Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>]

Thanks for all the replies.  I had it like this at one point, but  I kept putting plbhrs in my 'Group BY' , so I kept getting multiple records.  
I have it working now.
  
What a great community!!!!! 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Adam West
Sent: Monday, August 17, 2009 12:11 PM
To: Midrange Systems Technical Discussion
Subject: 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.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.