假设小明有100元，需要购买两种水果，利用SQL查询有几种购买方案.

Question

假设小明有100元，需要购买两种水果，利用SQL查询有几种购买方案.

Answer 1

SELECT
    CONCAT( t1.tname, t1.price ),
    CONCAT( t2.tname, t2.price ) 
FROM
    `table` t1,
    `table` t2 
WHERE
    t1.tname > t2.tname 
    AND t1.price = 100- t2.price