分析

关键词：order

多行排序:order by [列名1],[列名2],...

排序规则：asc---升序，desc---降序

代码

select quantity,item_price
from OrderItems
order by quantity desc,item_price desc