advanced code snippet search

Posted By

xavsio4 on 01/28/11


Tagged

Oracle


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

geekzspot


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

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. SELECT * FROM si_dm_daily_bal sample(5) ORDER BY dbms_random.value

Report this snippet  

You need to login to post a comment.