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.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.