HI - I'm trying to create deciles by using NTILE function in TOAD using the below syntax.
SELECT *, NTILE(10) OVER (ORDER BY SERVER_PREDICT) AS [Partition] FROM [dbo].[scores]
TOAD Version Used : V3.5
Any quick help would be highly appreciated.
NTILE is not implemented in Teradata, but similar syntax, check
Missing functions: CUME_DIST & NTILE