MySQL - How do I to select data from a table, ordering by the difference between the values of two columns?

Question

In a mysql table I have, I want to select all the rows and all the columns, but by ordering them by the difference between the values of two values of the same column. Is there a way to write such an SQL query? Thank you very much!

could you expand on `difference between the values of two values of the same column`? How do you know which to compare? — abhinav, Nov 24 '11 at 06:02

score 0 · Accepted Answer · answered Nov 24 '11 at 06:09

0

SELECT * FROM MyTable ORDER BY (ColumnA - ColumnB)

answered Nov 24 '11 at 06:09

Dylan Smith

22,069
2
47
62

But the question asked for `two values of the same column` – Ariful Islam Nov 24 '11 at 06:10
i hope this will helps you, http://stackoverflow.com/questions/634568/how-to-get-difference-between-two-rows-for-a-column-field – Nagarajan Nov 24 '11 at 06:28

MySQL - How do I to select data from a table, ordering by the difference between the values of two columns?

1 Answers1