Return a random sample of 5% of records of a table with Oracle

Revision: 40282

at January 28, 2011 19:39 by xavsio4

Initial Code

select * from si_dm_daily_bal sample(5) ORDER BY dbms_random.value

Initial URL

Initial Description

Initial Title

Return a random sample of 5% of records of a table with Oracle

Initial Tags

Oracle

Initial Language

SQL