Archives of the TeradataForum
Message Posted: Tue, 22 Mar 2005 @ 15:35:25 GMT
I'm running the following query:
Select Segment ,quantile(10, segment_value) as Decile from TableX
I expected this to split my data into 10 relatively even blocks of data (i.e. each deciles would have approx. same no. of rows), but they don't. Why not? Will the amount in each decile be very uneven if some rows have the same segment value?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|