SELECT T1.id FROM TB T1 WHERE NOT EXISTS(SELECT 1 FROM TB T2 WHERE T1.id=T2.id AND T1.类型<>T2.类型) GROUP BY T1.id
假设表的结构如下:CREATE TABLE t1 ( id int , typecode smallint )SQL语句:SELECT t1.* FROM t1 JOIN ( SELECT id FROM t1 GROUP BY id HAVING COUNT(*) = 1 ) u ON t1.id = u.id
FROM TB T1
WHERE NOT EXISTS(SELECT 1 FROM TB T2 WHERE T1.id=T2.id AND T1.类型<>T2.类型)
GROUP BY T1.id
假设表的结构如下:CREATE TABLE t1
(
id int
, typecode smallint
)SQL语句:SELECT
t1.*
FROM t1
JOIN (
SELECT
id
FROM t1
GROUP BY id
HAVING COUNT(*) = 1
) u ON t1.id = u.id