Greatest Function in Netezza

sql netezza
user2740397 picture user2740397 · Sep 2, 2013 · Viewed 11.5k times · Source

Am trying to find the equivalent statement to below in Netezza

greatest(table1.column1, table2.column2, table3.column3)

also

least(table1.column1, table2.column2, table3.column3)

all the columns are dates

Any help is appreciated.

Answer

Alex picture Alex · Apr 8, 2017

In newer versions of Netezza, this will also work:

max(table1.column1, table2.column2, table3.column3)
min(table1.column1, table2.column2, table3.column3)

Related questions

How to delete duplicate rows without unique identifier

I have duplicate rows in my table and I want to delete duplicates in the most efficient way since the table is big. After some research, I have come up with this query: WITH TempEmp AS ( SELECT name, ROW_NUMBER() …

Read More
Netezza SQL syntax to convert numeric YYYYMMDD format into date

We have a Netezza table that contains dates stored in a numeric YYYYMMDD format (eg 20090731). What is the best Netezza syntax to use to convert this into date format? eg SELECT somefunction(20090731) as NZDATE ?

Read More
How do I list all the column names in Netezza?

Is there a query I can write to search all the column names for a particular database in Netezza?

Read More