Archives of the TeradataForum

Message Posted: Thu, 21 Apr 2011 @ 11:47:45 GMT

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

Number of rows in an unknown partition:

     sel partition,count(*)
       from kris.t10
       where partition=(sel max(a.partition)
                          from kris.t10 a)
       group by 1;

Number of rows in No range partition:

     sel partition,count(*)
       from kris.t10
       where partition=(sel max(a.partition)-1
                          from kris.t10 a)
       group by 1;

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