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.