MYSQL按列总和排序 [英] MYSQL Order By Sum of Columns

问题描述

关于如何按两列的总和而不是按单列对MYSQL查询的结果进行排序的想法吗?

Any idea on how to order the results of a MYSQL query by the sum of two columns rather than by a single column?

Select * FROM table ORDER BY (col1+col2) desc

我知道那行不通.，但我希望它能传达我想要做的很好的事情.

I know that won't work., but I hope it conveys what I want to do fairly well.

谢谢！

推荐答案

为什么在得出结论不起作用之前不尝试?实际上，确实如此.

Why not try before concluding it doesn't work? In point of fact, it does.

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