SQL Reference
DESelect builds SQL queries so you don't have to. Learn how DESelect can replace each functionality of SQL.
- Is ROW_NUMBER() supported in DESelect?
- Is DISTINCT supported in DESelect?
- Is CASE WHEN/THEN supported in DESelect?
- Can you use functions like COUNT(), AVG(), SUM(), MAX() and MIN() in DESelect?
- Is comparing fields across data extensions supported in DESelect?
- Are UNIONs supported in DESelect?
- Is it possible to query on precise (calendar) time in DESelect?
- Are SQL operators "=" , "<>", "<", ">", "<=", ">=" available in DESelect?
- Are SQL statements IS NULL / IS NOT NULL supported in DESelect?
- Is DATEADD supported in DESelect?
- Are (NOT) IN/ EXISTS statements followed by a subquery supported in DESelect?
- Can you use IN / NOT in criteria in DESelect to filter on a list of values?
- Is the LIKE operator supported in DESelect?
- Are JOINs supported in DESelect?