Re: Tricky question for simple SQL

> YEAR MONTH ADJUST_DEMAND_ID OBJECT_VALUE PRT_ID
I think of something like:

SELECT YEAR, MONTH, ADJUST_DEMAND_ID, OBJECT_VALUE, MAX(PRT_ID)   FROM
   (
 SELECT YEAR, MONTH, ADJUST_DEMAND_ID, PRT_ID, MAX(OBJECT_VALUE) OBJECT_VALUE
    FROM XXXX
 GROUP BY YEAR, MONTH, ADJUST_DEMAND_ID, PRT_ID )
 GROUP BY YEAR, MONTH, ADJUST_DEMAND_ID, OBJECT_VALUE;

--
TomekB

PS. I haven't checked it...