SQL Reference
DESelect builds SQL queries so you don't have to. Learn how DESelect can replace each functionality of SQL.
- What is the difference between a "With All" match type and Append Data Extensions?
- Can I do Cross Joins or Cartesian Products between two Data Extensions in DESelect Segment?
- SQL Cheat Sheet
- Is ROW_NUMBER() supported in DESelect?
- Is DISTINCT supported in DESelect?
- Is CASE WHEN/THEN supported in DESelect?
- How to use functions like COUNT(), AVG(), SUM(), MAX() and MIN() in DESelect Segment?
- Is comparing fields across Data Extensions supported in DESelect?
- Are UNIONs supported in DESelect Segment?
- Are SQL operators "=" , "<>", "<", ">", "<=", ">=" available in DESelect?
- Are SQL statements IS NULL / IS NOT NULL supported in DESelect?
- Is DATEADD supported in DESelect Segment?
- Are (NOT) IN statements followed by a subquery supported in DESelect Segment?
- How is the LIKE operator supported inside DESelect Segment?