SQL Reference
- 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?