-- Select invoices larger than all invoices of client 3
USE sql_invoicing;
SELECT *
FROM invoices
WHERE invoice_total >(
SELECT MAX(invoice_total)
FROM invoices
WHERE invoice_id = 3
)
Other solution(with ALL 关键字):
USE sql_invoicing;
SELECT *
FROM invoices
WHERE invoice_total > ALL(
SELECT invoice_total
FROM invoices
WHERE invoice_id = 3
)
-- ALL返回()里面所有的值,和invoice_total 逐一比较
Output: