本文介绍了两列之间的排序差异的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有两列(购买价格和售价),我想计算它们之间的差额.之后,我想订购结果,以便查看所有利润率.
I have two columns (buying prince and sale price) and I want to calculate the difference between them. After that I want to order the result so I can see all the profit margins.
我可以只使用一条SELECT语句吗?
谢谢!
推荐答案SELECT (sale_price - buy_price) AS profit FROM table_name ORDER BY profit DESC
更多推荐
两列之间的排序差异
发布评论