Skip to main content
DESelect Help Center home page Support Portal
Community Submit a request
Sign in
  1. DESelect
  2. SQL Reference
  3. SQL Reference

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?
Copyright © DESelect bv. All rights reserved.
  • DESelect Security
  • DESelect.com
  • Trust Status Page
  • Privacy Policy
  • Terms of Service