Subject Re: GROUP BY
Author grat007
and this?

SELECT P1,P2,P3 FROM TABLE1 WHERE P1 IN (SELECT P1 FROM TABLE GROUP BY P1)