SQL 复杂查询问题！！

[宇宙最强皮皮虾]

条件一：查询agreement_projectid一样，并且它的对应列agreement_project_error都等于0的出来。

条件二：查询agreement_projectid一样，并且它的对应列agreement_project_error只要有一个为1就查询出来。

[lyangsoft]

SELECT agreement_projectid 
  FROM table_name 
 GROUP BY agreement_projectid 
 HAVING MAX(agreement_project_error) = 0;
 --按照agreement_projectid分组 取agreement_project_error最大值为0的数据 
 --最大值为0 则全部为0
 
SELECT DISTINCT agreement_projectid FROM table_name WHERE agreement_project_error = 1;
--存在agreement_project_error = 1的数据都列出来 然后去重

[宇宙最强皮皮虾]

引用 1 楼 u012355452 的回复:

SELECT agreement_projectid 
  FROM table_name 
 GROUP BY agreement_projectid 
 HAVING MAX(agreement_project_error) = 0;
 --按照agreement_projectid分组 取agreement_project_error最大值为0的数据 
 --最大值为0 则全部为0
 
SELECT DISTINCT agreement_projectid FROM table_name WHERE agreement_project_error = 1;
--存在agreement_project_error = 1的数据都列出来 然后去重

真有想法啊。 最大值为0 则全部为0这个想法好啊 按照你的问题已得到解决。大神