1) count total number of record from the table
select count(*) from customers;
2)100 records out of 100000, is 100/100000 = 0.1 percent
3) use following query
select * from customers SAMPLE(0.1), which will return 100 records randomly each time
No comments:
Post a Comment