Archive for the 'SQL Tricks'

How to “Undo” a Delete, Update, or Insert in Netezza

The great thing about Netezza is it does...
Read more

Efficient Data Upload Method Via External Table

If you ever have tried to upload data to Netezza...
Read more

Returning and Saving Large Result Sets Locally

Some of the common SQL Query tools like Squirrel...
Read more

An Integer Check That Doesn’t Blow Up

Sometimes you load in data sourcing from...
Read more

Alternate Method For Sequences

So if you’ve used Netezza sequences you may...
Read more

Rownum In Netezza?

Those of you coming from the Oracle world may...
Read more