我如何获得project_id，它具有一行一行的tech_id = 1和technology_id = 2？
+------------+---------------+
| project_id | technology_id |
+------------+---------------+
| 1 | 1 |
| 1 | 2 |
| 3 | 2 |
| 7 | 1 |
| 9 | 1 |
+------------+---------------+
按分组，product_id并仅接受同时具有technology_ids的那些分组
select project_id
from your_table
where technology_id in (1,2)
group by project_id
having count(*) = 2
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句