第六章 6-Any关键字|any keyword--Mosh my SQL

any或者some，也就是任何值。

1.select clients with at least two invoices

步骤一：计算每个客户的发票数

select
client_id,count(*)
from invoices
group by client_id

步骤二：筛选大于2张发票的

select
client_id,count(*)
from invoices
group by client_id
having count(*)>=2

2，如果要得到，上述有两张以上发票的客户的具体信息

select *
from clients
where client_id in(
    select
    client_id
    from invoices
    group by client_id
    having count(*)>=2)

注意：1，这里要用in,用=会显示Error Code: 1242. Subquery returns more than 1 row

如果要用=，那么要在等号之后加上any 。=any即in

select *
from clients
where client_id =any(
    select
    client_id
    from invoices
    group by client_id
    having count(*)>=2)

2，select client_id,count(*)，这个要去掉，不然 Error Code: 1241. Operand should contain 1 column(s)