Archives of the TeradataForum
Message Posted: Thu, 15 Jun 2006 @ 09:48:52 GMT
Subj: | | Re: Generation of Sequential Rows |
|
From: | | Victor Sokovin |
My suggestion is to investigate how the table is populated and try to "implant" a parallel process which would calculate the results you
require.
What you see in the table is called "sparse rank". What you want to calculate is called "row number". Please refer to the following thread to
get more information on different forms of ranking for ordered data sets:
www.teradataforum.com/teradata/20050724_152509.htm
.
Regards,
Victor
|