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.

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