SQL Cheat Sheet

this enables users who know sql to quickly connect with how different functions are represented in deselect segment https //drive google com/file/d/1uumlj2gzo3kngcsnr9ikkpr5hrauvirq/view 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