Re: SQL help with MAX function and group by

Try this one:

SELECT Y.EMP,

	   Y.DAT,
	   Y.GOAL
FROM   TESTVIEW Y,
       (
       SELECT   EMP,
       	     MAX(GOAL) MAX_GOAL
       FROM     TESTVIEW
       GROUP BY EMP
       ) X
WHERE  Y.EMP = X.EMP
AND	   Y.GOAL = X.MAX_GOAL

Result:

Row# EMP DAT GOAL

1	1	11/16/2005	5
2	2	11/15/2005	9
3	3	11/15/2005	4

sim Received on Thu Nov 17 2005 - 05:09:25 CST