Create a sample table - EDIT: Solved- I was using the wrong tablename

Database
New Member

Create a sample table - EDIT: Solved- I was using the wrong tablename

Hi, I want to use sample and create table.  I am having trouble combining them.  So, lets say tablename has 500 rows.

 

select * from tablename sample 100  --works

 

create table test1 as (

select * from tablename sample 100  ) with data  -- does not work.  It returns 500 rows instead of 100.

 

Please help,

Best,

Harry