记录工作中 查询相同 ID下某一列全部相同的 sql 语句

https://blog.csdn.net/weixin_36432451/article/details/113614517

 

 

 

 

SELECT
    *
FROM
    wo_permit
GROUP BY
    wo_id
HAVING
    GROUP_CONCAT(DISTINCT permit_status) = 6