Q&A for finance professionals and academics
WITH data (f) AS ( SELECT 'abc' UNION ALL SELECT 'def' UNION ALL SELECT 'abc' ) SELECT a.f, NEWID() FROM data a , data b, data c, data d, data e, data g WHERE a.f + g.f >= c.f + d.f