Archives of the TeradataForum

Message Posted: Wed, 07 Nov 2007 @ 19:45:11 GMT

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

Use derived table as below.

     SELECT A1.OFFICE, SUM(A1.HOURS) AS HOURS, (SUM(A1.HOURS) /HR)HRPCT FROM
     (SELECT
     SUM(A2.HOURS) FROM TABLE AS A2) DT(HR), TABLE AS A1
     WHERE A1.OFFICE LIKE 'AD%'
     GROUP BY A1.OFFICE;

Thanks,

Kumar Duraisamy

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