Netezza SQL analytic functions

IBM® Netezza® SQL supports many of the ANSI SQL:1999 standard analytic functions and some extensions. Using analytic functions in your business intelligence queries provides the following benefits:

• Improved query processing

  Using these functions results in better performance because the system no longer must conduct complex procedural processing and instead can conduct simple SQL queries.

• Enhanced productivity

  You can do complex analysis with clearer, more concise code. The code is quicker to formulate and easy to maintain.

• Easy to learn

  The functions use existing aggregate functions and thus use known syntax.

• Standardized syntax

  Because these functions are part of the ANSI standard, they are supported in many software packages.

The Netezza system also supports the development and use of user-defined functions and aggregates. This feature is described in the IBM Netezza User-Defined Functions Developer's Guide, which is available from Netezza for users who are participating in the Netezza Developer Network.