Archives of the TeradataForum

Message Posted: Mon, 30 Jun 2003 @ 15:25:05 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Rohit,

The quickest and easiest way that comes to mind is

sel *
sample 5
from db.tbl
;

There are other ways including using RETLIMIT, but this usually returns a 'statistically' valid sample.

Best regards,

John Berg

	<Prev	Next>		<<First	<Prev	Next>	Last>>