Sorted difference between two columns

Question

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.

Can I do it with just one SELECT statement?

Thanks!

score 17 · Accepted Answer · answered Sep 11 '11 at 16:04

17

  SELECT (sale_price - buy_price) AS profit
    FROM table_name
ORDER BY profit DESC

answered Sep 11 '11 at 16:04

Joe

15,669
4
48
83

score 6 · Answer 2 · answered Sep 11 '11 at 16:14

6

Joe has it, but I think you might be looking for something slightly different for the ordering.

Profit margin is defined as net income / revenue.. so the profit margin of each product would be (sale_price minus buy price) divided by sale_price.

SELECT (sale_price - buy_price) AS profit FROM table_name 
ORDER BY ((sale_price - buy_price) / sale_price) DESC

Good luck.

answered Sep 11 '11 at 16:14

psarid

450
7
19

Why not just re-use `profit` in the `ORDER BY` rather than doing `sale_price - buy_price` again? :) – Joe Sep 11 '11 at 16:17
@Joe True. Didn't think that far ahead :) – psarid Sep 11 '11 at 16:51

Sorted difference between two columns

2 Answers2

Linked