编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE F0916 (
    num int
);
INSERT INTO F0916 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9);

select * from F0916;
-- 求出每3个或2个相加的和等于10
SELECT
    a.num num1, b.num num2, c.num num3
FROM
    F0916 a,
    F0916 b,
    F0916 c
WHERE
    (a.num + b.num + c.num = 10) and a.num > b.num and b.num > c.num
UNION
SELECT
    a.num, b.num, NULL
FROM
    F0916 a,
    F0916 b
WHERE
    (a.num + b.num = 10) and a.num > b.num;