RE: Need help with SQL group by

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.