Question: what is the difference between top and sample in teradata?
Answer: From TOP vs SAMPLE: TOP 10 means "first 10 rows in sorted order". If you don't have an ORDER BY, then by extension it will be interpreted as asking for "ANY 10 rows" in any order. ... SAMPLE, as you have observed, does extra processing to try to randomize the result set yet maintain the same approximate distribution.