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

1 REPLY
Senior Apprentice

Re: NTILE Function in TOAD

Hi Parvathi,

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

Missing functions: CUME_DIST & NTILE