今日成果:
select *,quantity * unit_price as total_price
from order_items
where order_id = 2
order by total_price desc;
-- order by 可以排序列或者表达式,并且可以对多个字段进行排序
-- desc 表示降序排序
感谢各位读者查阅,欢迎各位👍点赞✍评论⭐收藏!
今日成果:
select *,quantity * unit_price as total_price
from order_items
where order_id = 2
order by total_price desc;
-- order by 可以排序列或者表达式,并且可以对多个字段进行排序
-- desc 表示降序排序
感谢各位读者查阅,欢迎各位👍点赞✍评论⭐收藏!