Archives of the TeradataForum

Message Posted: Thu, 29 Sep 2005 @ 14:11:29 GMT

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

If you can afford to do the count, this works:

     SELECT PARTITION        AS PARTT
           ,COUNT (*)        AS NBRROWS
       FROM databasename
      GROUP BY 1
      ORDER BY 1;

Don Stubbs
Teradata Certified Master

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