Tuesday, February 28, 2012

intersect example

SELECT numFROM(SELECT 0 AS numUNION ALL
SELECT 0 AS Expr1UNION ALL
SELECT 5 AS Expr1UNION ALLSELECT - 55 AS Expr1) AS aINTERSECT
SELECT numFROM(SELECT 0 AS numUNION ALL
SELECT 0 AS Expr1UNION ALL


results : 0,5
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)