今日成果:
select * from invoices
where invoice_total > all (
select invoice_total from invoices where client_id = 3);
select * from invoices
where invoice_total > (
select max(invoice_total)
from invoices where client_id = 3
);
-- 两种方法查询结果相同
感谢各位读者查阅,欢迎各位👍点赞✍评论⭐收藏+关注!