Archives of the TeradataForum

Message Posted: Wed, 02 Jan 2013 @ 09:42:32 GMT

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

Hi James,

You can try the following method , though it's not as direct as Creating a Table directly with sample data , but still should solve your purpose:

     -------------------------------------------------
     CT DB.ABC_test AS DB.ABC WITH NO DATA ;
     -------------------------------------------------
     INSERT INTO DB.ABC_test
     SEL * FROM
     DB.ABC  SAMPLE 0.1
     -------------------------------------------------
     SEL COUNT(*)
     FROM DB.ABC
     --
     115

     -------------------------------------------------
     SEL COUNT(*)
     FROM DB.ABC_test
     --
     COUNT(*)
     12;
     -------------------------------------------------

Regards,

Manish Mishra

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