HI - I'm trying to create deciles by using NTILE function in TOAD using the below syntax.
NTILE(10) OVER (ORDER BY SERVER_PREDICT) AS [Partition] FROM [dbo].[scores]
TOAD Version Used : V3.5
Any quick help would be highly appreciated.
The link about missing functions is outdated, it seems. CUME_DIST is supported in Teradata 16. (I couldn't comment on the blog post)
Yep, CUME_DIST is available since TD14.10, the last comment on the blog already added that.
But NTILE is still missing.
DENSE_RANK was also added in 14.10, and 16.10 finally got LAG & LEAD :-)