Wednesday, January 29, 2020

random choose small set of rows from oracle table

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