Dual in Netezza
When you're used to doing queries in Oracle SQL it can be confusing at times when you start working in Netezza.
While most of the time the syntax is the same, some functions that you're used to using are just not there anymore.
One of them - is dual.
Luckily a quick google on the topic points you straight to the answer. - "_v_dual".
Ie: select sysdate from _v_dual;
Another interesting thing that I recently discovered while working in Netezza is the existence (I'm a really really new user to Netezza) of a spatial module that contains a lot of geo-related functions.
Can't wait to try those out. Will share any stuff that I find soon.