两列之间的排序差异 [英] Sorted difference between two columns

问题描述

我有两列(购买价格和售价)，我想计算它们之间的差额.之后，我想订购结果，以便查看所有利润率.

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

这篇关于两列之间的排序差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！