RE: Need help with SQL group by

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

> 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
>
> I am trying to get 1 record per employee, but I cannot find the 
> correct solution.
> What am I missing here?

If you want one record per employee, then you must group at the employee
level.

You can use (for example) MAX(EENAM) to get around some of the other
language requirements.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"I'm living so far beyond my income that we may almost be said to be living
apart."
        -- e e cummings