Just give it to me at random SQL

 
create table my_table_by_taking_a_random (some_records integer);

insert into  my_table_by_taking_a_random 
  select rownum from dual connect by level <= 100;

commit;
--repeat the following query a few times
--you'll get a 1% approximation of the data (0-3 records) chosen at random
select some_records
from   my_table_by_taking_a_random sample (1);

select some_records
from   my_table_by_taking_a_random sample (1);

select some_records
from   my_table_by_taking_a_random sample (1);

drop table my_table_by_taking_a_random purge;

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)