Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which query will return a sample of 1000 rows from a table named testtable, where each row has a 10% probability of being included in the sample?
testtable
A
select * from testtable sample (0.1);
B
select * from testtable sample (10);
C
select * from testtable sample (0.1 rows);
D
select * from testtable sample (10 rows);