Archives of the TeradataForum

Message Posted: Tue, 02 Feb 2010 @ 22:42:31 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Might try

     SELECT COUNT(*)
     FROM   (SELECT vprid
             FROM   DBC.ResUsageSvpr
             WHERE VPRTYPE = 'PE'
             GROUP BY 1) A;

Thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>