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.