How can we achieve the same functionality as of 'SEQUENCE' in provided in Netezza?
Please find below the link demonstrating the functionality I would like to achieve in Big query :
I have reviewed RANK() but this is not solving my purpose to the core. Any leads would be appreciated.