Skip to main content
Stack Overflow Jobs powered by Indeed: A job site that puts thousands of tech jobs at your fingertips (U.S. only). Search jobs

New answers tagged

0 votes

SQL - How to filter the max value

You could do with Sort and Limit: SELECT TOP 1 GlobalID, CategoryDescription, MAX FROM Your_Data_Extension ORDER BY MAX DESC
Eduardo Ruiz de Pascual's user avatar
1 vote

Marketing Cloud - SQL Contatenate columns in alphabetical order

If you're wanting to sort and concatenate all of the field values, you can do something like this: CREATE TABLE OCP_CONTACT_EVENT_REASON_DETAIL_constraints ( field1 varchar(10) , constraintl ...
Adam Spriggs's user avatar
  • 30.7k
0 votes

Marketing Cloud SQL - check JSON array size

The actual solution that I found is to count repetitions of given string in the JSON structure. For example: the key "logical_attribute_name" has 22 characters. With this code snippet I can ...
MrSkover's user avatar

Top 50 recent answers are included