请问 SQL (mysql) 如何查询相同 ID下某一列全部相同的 sql 语句怎么写?-灵析社区

万码F5GTP6P0

select * from (select wextid,result from t_test group by wextid,result) a group by wextid having count(1)=1 and result = 'error'

阅读量:1

点赞量:0

问AI