Tag Archives: row_number

Alternate Method For Sequences

So if you’ve used Netezza sequences you may have noticed they are all over the place, and far from sequential.  This is just the nature of a share nothing massively parallel architecture.  But if you want sequential sequences that automatically … Continue reading

Posted in SQL Tricks | Tagged , , | Leave a comment

Rownum In Netezza?

Those of you coming from the Oracle world may find you are missing a ROWNUM pseudo column in Netezza.  Sure there’s the LIMIT clause, but sometimes you have a need to assign a sequential number to each row.  The best solution … Continue reading

Posted in SQL Tricks | Tagged , , , | 2 Comments