Tag Archives: rownum

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