Archives of the TeradataForum

Message Posted: Wed, 20 Nov 2002 @ 18:33:26 GMT

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

Hi List,

Can anyone pls explain me this query!

SELECT AVG(Daily_Amt) AS Daily_Average FROM (SELECT
SUM(Sales_Amount) FROM Sales_Hist GROUP BY
Period_Date) Temp(Daily_Amt);

Thanks in advance

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