Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Creating a new table by copying other table with a portion of data
 
From:   Mishra, Manish

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023