Return to Answer

wrong code

Source Link

edited Mar 10, 2015 at 20:50

79.4k
5
51
117

SELECT  LEAST(source, dest),
        GREATEST(source, dest),
        SUM(IF(source < dest, sourcevalue, 0)),
        SUM(IF(source <> dest, destvalue, 0))
    FROM  tbl
    GROUP BY  1,2;

SELECT  LEAST(source, dest),
        GREATEST(source, dest),
        SUM(IF(source < dest, source, 0)),
        SUM(IF(source < dest, dest, 0))
    FROM  tbl
    GROUP BY  1,2;

SELECT  LEAST(source, dest),
        GREATEST(source, dest),
        SUM(IF(source < dest, value, 0)),
        SUM(IF(source > dest, value, 0))
    FROM  tbl
    GROUP BY  1,2;

Source Link

created Mar 10, 2015 at 6:45

Rick James

79.4k
5
51
117

SELECT  LEAST(source, dest),
        GREATEST(source, dest),
        SUM(IF(source < dest, source, 0)),
        SUM(IF(source < dest, dest, 0))
    FROM  tbl
    GROUP BY  1,2;