更新时间:2023-08-25 23:13:22
有一个子查询,返回具有所有 3 个模型 (1081,1082,1083) 的引擎.
Have a sub-query that returns engines having all 3 models (1081,1082,1083).
select color
from car
where engine in (
select engine
from car
where model in (1081,1082,1083)
group by engine
having count(distinct model) = 3)