Warning: Creating default object from empty value in _dxcontentbanner_set_details_blog() (line 206 of /appl1/devx/drupal/sites7/all/modules/devx/modules/dxcontentbanner/dxcontentbanner.inc).
Subscribe to Blog content and comments for dnoeth Blog Archive: May 2011
Missing functions: CUME_DIST & NTILE
Posted 25 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.

 16143 views 6 comments
CUME_DIST is available in 14.10
alteves
Missing Functions: DENSE_RANK
Posted 16 May 2011

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.

 23510 views 9 comments
-- Another Example to Get nth highest salaried employee SELECT empNo ,salary ,prev_value ,SUM(CASE WHEN prev_value = salary THEN 0 ELSE 1 END) OVER ( ORDER BY salary DESC ...
abhijeetgupta29nov