There are a few ways to get sample records in Teradata. The other method is to use the TOP command: sel top 100 from tablename; That will give you a sample of 100 different records from the table. NCR NR0-017 Teradata Masters Update V2R5 Practice Exam Set 2 ... For large sample sizes, proportional allocation is faster than RANDOMIZED ALLOCATION. Question on randomized allocation teradata community. The requested sample size is divided by the number of rows and each AMP retrieves a part of the sample. Syntax for SAMPLE function: SAMPLE [WITH REPLACEMENT] [RANDOMIZED ALLOCATION] [WHEN THEN] { | } […, | ] [ELSE { | THEN] { | } […, | ] [ELSE { | THEN] { | } […, | ] [ELSE { | THEN] Chapter 25 - Sample “The universe extends beyond the mind of man, and is more complex than the small sample one can study.” - Kenneth L. Pike The SAMPLE Function … - Selection from Teradata SQL [Book] Teradata is by default case insensitive. Syntax for SAMPLE function: SAMPLE [WITH REPLACEMENT] [RANDOMIZED ALLOCATION] [WHEN THEN] { | } […, | ] [ELSE { |