sql语句有点复杂:
SELECT
t1.a,
t1.b,
t1.c
FROM
demo AS t1
WHERE
t1.a NOT IN (
SELECT
a
FROM
demo
WHERE
t1.id != id
)
AND
t1.a NOT IN (
SELECT
b
FROM
demo
WHERE
t1.id != id
)
AND
t1.a NOT IN (
SELECT
c
FROM
demo
WHERE
t1.id != id
)
AND
t1.b NOT IN (
SELECT
a
FROM
demo
WHERE
t1.id != id
)
AND
t1.b NOT IN (
SELECT
b
FROM
demo
WHERE
t1.id != id
)
AND
t1.b NOT IN (
SELECT
c
FROM
demo
WHERE
t1.id != id
)
AND
t1.c NOT IN (
SELECT
a
FROM
demo
WHERE
t1.id != id
)
AND
t1.c NOT IN (
SELECT
b
FROM
demo
WHERE
t1.id != id
)
AND
t1.c NOT IN (
SELECT
c
FROM
demo
WHERE
t1.id != id
)