Category
Command/Function
Description Example
Data Selec SELECT Retrieves dSELECT * FROM DataExtension
Joins JOIN (INNECombines dSELECT * FROM DataExtension1 JOIN DataExtension2 ON [Link] = Da
Filtering WHERE Filters rowSELECT * FROM DataExtension WHERE Status = 'Active'
Ordering ORDER BY Sorts the r SELECT * FROM DataExtension ORDER BY EmailAddress ASC
Remove Dup DISTINCT Returns uniSELECT DISTINCT EmailAddress FROM DataExtension
AggregatioGROUP BY Groups rows SELECT EmailAddress, COUNT(*) FROM DataExtension GROUP BY EmailAddress
ConditionaHAVING Filters gro SELECT EmailAddress, COUNT(*) FROM DataExtension GROUP BY EmailAddress HAVING COUN
Data InsertINSERT IN Inserts newINSERT INTO NewDataExtension SELECT * FROM DataExtension
Data UpdaUPDATE Updates exiUPDATE DataExtension SET Status = 'Inactive' WHERE LastLoginDate < DATEADD(year, -1, GET
Data DeletDELETE Deletes row DELETE FROM DataExtension WHERE Status = 'Unsubscribed'
ConditionalCASE Applies conSELECT EmailAddress, CASE WHEN Clicks > 5 THEN 'Engaged' ELSE 'Not Engaged' END AS Enga
Row CountCOUNT() Counts theSELECT COUNT(*) FROM DataExtension
Summing VSUM() Calculates SELECT SUM(TotalRevenue) FROM DataExtension
Average CaAVG() Calculates SELECT AVG(TotalSpent) FROM DataExtension
Maximum/M MAX() / MIFinds the SELECT MAX(PurchaseAmount) FROM DataExtension
Date Arith DATEADD()Adds a specSELECT * FROM DataExtension WHERE PurchaseDate >= DATEADD(day, -30, GETDATE())
Date Diffe DATEDIFF()Calculates SELECT DATEDIFF(day, LastLoginDate, GETDATE()) AS DaysSinceLastLogin FROM DataExtensio
String ManUPPER() / Converts teSELECT UPPER(EmailAddress) FROM DataExtension
Substring ESUBSTRINGExtracts a SELECT SUBSTRING(EmailAddress, 1, 5) FROM DataExtension
Dynamic DaGETDATE()Returns th SELECT * FROM DataExtension WHERE LastPurchaseDate >= GETDATE()
Handling NISNULL() / Replaces nuSELECT ISNULL(PhoneNumber, 'No Phone') FROM DataExtension
Pattern MaLIKE Filters res SELECT * FROM DataExtension WHERE EmailAddress LIKE '%[Link]'
BehavioralJOIN with Queries enSELECT [Link] FROM DataExtension de JOIN _Click e ON [Link] = [Link]
[Link] = [Link]
BY EmailAddress
BY EmailAddress HAVING COUNT(*) > 5
Date < DATEADD(year, -1, GETDATE())
SE 'Not Engaged' END AS EngagementStatus FROM DataExtension
DD(day, -30, GETDATE())
LastLogin FROM DataExtension
ON [Link] = [Link] WHERE [Link] > GETDATE()
