SQL Cheat Sheet – DESelect

This enables users who know SQL to quickly connect with how different functions are represented in DESelect Segment.

Overview

SQL function	DESelect Segment function
SELECT	Available fields to be selected as Target Data Extension fields
FROM	Selected Data Extensions section
WHERE	Filters section
UNION	Append Data Extension
LEFT JOIN	WITH/WITHOUT MATCHING
INNER JOIN	WITH MATCHING
RIGHT JOIN	WITH/WITHOUT MATCHING
LEFT JOIN EXCLUSION	WITHOUT MATCHING
RIGHT JOIN EXCLUSION	WITHOUT MATCHING
FULL OUTER JOIN	WITH ALL
IS NULL/IS NOT NULL	Is empty/Is not empty
LIKE	Begins with, Ends with, Contains, Does not Contain
HAVING	fx function, predefined relations
EXIST/IN	In Results/Not In Results
"=" , "<>", "<", ">", "<=", ">="	Equal to, Not Equal to, Smaller than, Greater than, Smaller than or equal to, Greater than or equal to
DISTINCT	Prio Deduplication
LIMIT AND ORDER BY	Sort and Limit
CASE WHEN/THEN	Dynamic Custom Value
SUM(), AVG(), MAX(), MIN(), COUNT() GROUP BY	Aggregations Custom Value
DATEDIFF	Date Difference Custom Value
DATEADD	Transform Date Custom Value
ROW_NUMBER()	Row Number Custom Value
GETDATE()	Timestamp Custom Value
Other SQL functions	Apply any function Custom Value

Related articles