Archives of the TeradataForum

Message Posted: Fri, 18 Oct 2002 @ 17:11:35 GMT

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

TRY THIS:

SELECT TABLENAME, SUM(CURRENTPERM)
FROM DBC.TABLESIZE
WHERE DATABASENAME = databasename
AND TABLENAME = 'tablename'
GROUP BY TABLENAME;

Raghav

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