多次select查询结果的交集，请问SQL语句如何写

表A有2个字段id,aidmysql> select id from a where aid=5;+----+| id |+----+| 1 || 2 || 4 |+----+3 rows in set (0.00 sec)mysql> select id from a where aid=6;+----+| id |+----+| 1 || 4 |+----+2 rows in set (0.00 sec)我想取这2条查询结果的交集，请问SQL语句如何写。也就是结果id:1,4mysql> select id from a where aid=5;+----+| id |+----+| 1 || 2 || 4 |+----+3 rows in set (0.00 sec)mysql> select id from a where aid=6;+----+| id |+----+| 1 || 4 |+----+2 rows in set (0.00 sec)

mysql这垃圾不支持交集的。如果是数据库那么SQL如下SELECt id FROM a WHERe aid=5 INTERSECTSELECt id FROM a WHERe aid=6

你好！ 条件and? 如有疑问，请追问。

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息