 |
 |
Archives of the TeradataForum
Message Posted: Fri, 26 Mar 2004 @ 20:04:11 GMT
Subj: | | Re: SAMPLE syntax |
|
From: | | Jeremy Christiansen |
| "fraction_description: any set of unsigned floating point constant numbers in the closed interval (0,1) that specifies the percentage of
rows to be sampled for a true search condition." | |
They may have said "closed" but the mathematical expression (0,1) designates an "open" interval. Looks like the endpoints 0 and 1 are not
allowed insofar as the "fraction_description" syntax goes. Note that .0 gives you an error and 1.0 is interpreted as a "count_description" (as the
original poster pointed out).
| |