Subscribe to Blog content and comments for dnoeth Blog Archive: May 2011

In my previous post i covered some ranking functions including SQL:2008 RANK, ROW_NUMBER & DENSE_RANK.

But Standard SQL defines three additional functions based on ranking:
PERCENT_RANK and CUME_DIST as relative rankings and a percentile calculation named NTILE.

Some of the SQL:2008 analytical functions are not implemented in Teradata, but most of them can be re-written using existing features.
In this post I will cover the ranking algorithms including DENSE_RANK.