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