In an earlier post about "Random Sampling using SQL", we use functions mode and dbms_random.random to randomly sample 30% of records. This can also be done easily with oracle sample clause as the following:
select * from TBL_TEST sample(30);
Sample clause is also a great way to test the performance of a query before we run it on large tables.
Popular Topics
Popular Topics
Showing posts with label select with sample clause. Show all posts
Showing posts with label select with sample clause. Show all posts
Subscribe to:
Posts (Atom)