Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 04 Apr 2013 @ 10:21:41 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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)


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020