Get a random selection of rows from a table in Oracle Database with SELECT ... FROM ... SAMPLE ( N ) Where N is the percent of rows to get from 0.000001 to 100 This uses statistical sampling so will return approximately N% of the data #SQL