SELECT * FROM 表 A INNER JOIN
(select ID,(CASE 列1 WHEN 0 THEN 1 ELSE 0 END +
CASE 列2 WHEN 0 THEN 1 ELSE 0 END +
CASE 列3 WHEN 0 THEN 1 ELSE 0 END +
CASE 列4 WHEN 0 THEN 1 ELSE 0 END +
CASE 列5 WHEN 0 THEN 1 ELSE 0 END +
CASE 列6 WHEN 0 THEN 1 ELSE 0 END +
CASE 列7 WHEN 0 THEN 1 ELSE 0 END +
CASE 列8 WHEN 0 THEN 1 ELSE 0 END ) AS 个数 from 表) B
ON B.ID = A.ID AND B.个数 >=5
sum(CASE 列1 WHEN 0 THEN 1 ELSE 0 END
CASE 列2 WHEN 0 THEN 1 ELSE 0 END
CASE 列3 WHEN 0 THEN 1 ELSE 0 END
CASE 列4 WHEN 0 THEN 1 ELSE 0 END
CASE 列5 WHEN 0 THEN 1 ELSE 0 END
CASE 列6 WHEN 0 THEN 1 ELSE 0 END
CASE 列7 WHEN 0 THEN 1 ELSE 0 END
CASE 列8 WHEN 0 THEN 1 ELSE 0 END )AS 个数
是不是应该改为
((CASE 列1 WHEN 0 THEN 1 ELSE 0 END)
+(CASE 列2 WHEN 0 THEN 1 ELSE 0 END)
+(CASE 列3 WHEN 0 THEN 1 ELSE 0 END)
+(CASE 列4 WHEN 0 THEN 1 ELSE 0 END)
+(CASE 列5 WHEN 0 THEN 1 ELSE 0 END)
+(CASE 列6 WHEN 0 THEN 1 ELSE 0 END)
+(CASE 列7 WHEN 0 THEN 1 ELSE 0 END)
+(CASE 列8 WHEN 0 THEN 1 ELSE 0 END) )AS 个数
SELECT * FROM 表 A INNER JOIN
(select ID(主键),sum(CASE 列1 WHEN 0 THEN 1 ELSE 0 END
CASE 列2 WHEN 0 THEN 1 ELSE 0 END
CASE 列3 WHEN 0 THEN 1 ELSE 0 END
CASE 列4 WHEN 0 THEN 1 ELSE 0 END
CASE 列5 WHEN 0 THEN 1 ELSE 0 END
CASE 列6 WHEN 0 THEN 1 ELSE 0 END
CASE 列7 WHEN 0 THEN 1 ELSE 0 END
CASE 列8 WHEN 0 THEN 1 ELSE 0 END ) AS 个数 from 表) B
ON B.ID = A.ID AND B.个数 >=5
语法错误(操作符丢失)在查询表达试'sum(CASE 列1 WHEN 0 THEN 1 ELSE 0 END
CASE 列2 WHEN 0 THEN 1 ELSE 0 END
CASE 列3 WHEN 0 THEN 1 ELSE 0 END
CASE 列4 WHEN 0 THEN 1 ELSE 0 END
CASE 列5 WHEN 0 THEN 1 ELSE 0 END
CASE 列6 WHEN 0 THEN 1 ELSE 0 END
CASE 列7 WHEN 0 THEN 1 ELSE 0 END
CASE 列8 WHEN 0 THEN 1 ELSE 0 END '中。