NTILE Function in TOAD

Analytics

NTILE Function in TOAD

HI - I'm trying to create deciles by using NTILE function in TOAD using the below syntax.

Code :

 SELECT      *,

            NTILE(10) OVER (ORDER BY SERVER_PREDICT) AS [Partition]   FROM [dbo].[scores]

Error :

[Teradata Database] [3706] Syntax error: expected something between '(' and the integer '10'.

TOAD Version Used : V3.5

Any quick help would be highly appreciated.

Thanks,

Parvathi Patnaik

3 REPLIES
Junior Contributor

Re: NTILE Function in TOAD

Hi Parvathi,

NTILE is not implemented in Teradata, but similar syntax, check

Missing functions: CUME_DIST & NTILE

New Member

Re: NTILE Function in TOAD

The link about missing functions is outdated, it seems. CUME_DIST is supported in Teradata 16. (I couldn't comment on the blog post)

Junior Contributor

Re: NTILE Function in TOAD

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 :-)