Archives of the TeradataForum
Message Posted: Tue, 28 Oct 2008 @ 22:25:50 GMT
How randomized do you need the sample?
If it does have to be extremely random, you could do the following:
qualify count(*) over (partition by location rows unbounded preceding) <6
Hope this helps,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|