 |
 |
Archives of the TeradataForum
Message Posted: Thu, 04 Apr 2013 @ 10:21:41 GMT
| Subj: | | Re: Limit/Reset Rank |
| |
| From: | | Dieter Noeth |
Suyog Kakade wrote:
| | Thanks. That's the way to limit it. I'm looking to limit it as well as to reset it after it reaches certain count. | |
If you actually want to limit you don't need to reset :-)
| | Also, I want the next rank for the same partition to start from 2 instead of 32001 ( dense rank in oracle) | |
I don't get it. Could you be more specific, maybe showing some data? Do you have more than 32000 rows with the same RANK?
Otherwise you could do something like RANK MOD 32000 + 1 + (RANK / 32000)
Dieter
| |
