mysql - 带限制条件的sql语句groupby

Question

我想做的是返回卡车车主总数超过指定限制的所有记录在下面的情况下，假设总限制为 3，我想获取所有注册了 3 辆或更多卡车的车主

所以查询如果限制是 3 应该只返回 metro trans 因为他们有 3 辆或更多卡车

这是我的数据库结构

tbl_trucks
id   owner_id  .....
1    12
2    12
3    13
4    12

tbl_truck_owners
id   owner
12   metro trans
13   mush elec

如何将限制添加到我的sql语句中

这是我试过的

SELECT 
     COUNT(tbl_trucks.owner_id), tbl_truck_owners.owner
      FROM tbl_trucks
        LEFT JOIN tbl_truck_owners ON tbl_trucks.owner_id = tbl_truck_owners.id

        WHERE              //stuck at adding the limit

        GROUP BY owner_id"

如何添加限制

Answer 1

使用 HAVING 语句:

SELECT COUNT(tbl_trucks.owner_id), tbl_truck_owners.owner
FROM tbl_trucks
LEFT JOIN tbl_truck_owners ON tbl_trucks.owner_id = tbl_truck_owners.id
GROUP BY owner_id
HAVING COUNT(tbl_trucks.owner_id) >= 3