Issue with SQL View
When I tried to incorporate Rank() window function in SQL view, the rank() function of SQL Statement is automatically getting truncated and throws the following exception. Is there a limitation for certain SQL functions in views.
SQL Statement as given in the help page,
SELECT ProdName, Type, Sales, RANK() OVER ( PARTITION BY ProdName ORDER BY Sales DESC ) AS Rank FROM ProductSales ORDER BY ProdName, Type;
Thanks and Regards,