all使用是为了-- 大于id为3的顾客所有的发票金额的发票
use sql_invoicing;
select *
from invoices
where invoice_total > all (
select invoice_total
from invoices
where client_id = 3)
等同于
use sql_invoicing;
select *
from invoices
where invoice_total > -- 得出顾客3最大发票金额后筛选出比这金额更大的发票
(select max(invoice_total) -- max函数目的是为了得出顾客3中的最大发票金额
from invoices
where client_id = 3)