1

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

  • Because subscribers key is an alpha numberic value? – Samuel Dare Feb 20 at 20:44
0

Why do you need TOP 100 PERCENT? Just use SELECT * or name the columns that you want.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.