WITH data (f) AS ( SELECT 'abc' UNION ALL SELECT 'def' UN...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Quantitative Finance

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results