Archives of the TeradataForum
Message Posted: Tue, 21 Sep 2004 @ 11:12:36 GMT
Does anybody have any experience with RANK functionality and extra large tables. I'm having big time problems with making a simple question to work.
Table A = 1 billion rows
Task: to find top 10 destinations for Field 2. Possible variatoions in 'Field 1' are limited to 1'000 distinct values making resultset of 10'000 rows.
Select Field1, Field2, Sum(Usage) total, Rank() Partition by Field1 Order By Total Desc Group By ???
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|