Sampling a Table
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Sampling a Table
| Line 22: | Line 22: | ||
from iso_country | from iso_country | ||
sample (10) -- percentage of rows to display | sample (10) -- percentage of rows to display | ||
| + | </pre> | ||
| + | |||
| + | Additional conditions can be added to a sampling query, but they appear to be applied after the original sample has been taken, so there is no guarantee that the query will show any rows: | ||
| + | <pre> | ||
| + | select * | ||
| + | from iso_country | ||
| + | sample (10) | ||
| + | where code like 'A%' | ||
</pre> | </pre> | ||
