I am at the Parent Enterprise Level and trying to sort the SubscriberKey column from the All Subscribers List into a Target Data Extension: All_Subscribers_DE. The columns are populated but the ORDER BY is not working. No error.
SELECT TOP 100 PERCENT * FROM _Subscribers s ORDER BY [SubscriberKey] ASC
There are 1,582,522 records found. When I changed the 100 PERCENT to a number, the ORDER BY works:
SELECT TOP 1600000 * FROM _Subscribers s ORDER BY [SubscriberKey] ASC
But here SFMC uses percent as examples:
Random Sample of 33 Percent Exclusion https://help.salesforce.com/articleView?id=mc_as_sql_reference.htm&type=5