ALL

• ALL 比對subquery 所有的回傳值，要所有的回傳值都成立才成立(SQLite 不支援)

select car.cid,car.model ,car.price,car.price*sale.num

from car,sale where car.cid=sale.cid

and car.price*sale.num >

all

(

select car.price*sale.num from car,sale

where car.cid=sale.cid and car.model like '3%'

)