I want to order the result of my query result and put it via Query activity into a data extension (DE has no primary key). The order by MAWE is pretty important for me.
select count (SubscriberKey) AS amount, country, MAWE, variant from Sendfinal1 group by country,MAWE,variant order by MAWE,country
SF seems not to accept the order by:
Message: An error occurred while checking the query syntax. Errors: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.
Is there a workaround for that?