Archives of the TeradataForum

Message Posted: Thu, 21 Apr 2011 @ 09:53:55 GMT

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

Amit,

Just this script to identify the snapshot of partition number for NULL and NO RANGE, the number will change depend on the number of partition you specified,

     SELECT partition, col1
            , COUNT(*)
       FROM .
      WHERE col1 IS NULL
     GROUP BY 1
     ORDER BY 1 DESC

     SELECT partition, col1
            , COUNT(*)
       FROM .
      WHERE col1 = 
     GROUP BY 1
     ORDER BY 1 DESC

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