按两个字段的和 [英] Order By Sum of Two Fields

问题描述

假设我有一个包含karma_up和karma_down的表。每次有人投票karma_up得到增加，每次有人投票karma_down也增加一。我如何拉这些选择的行，并让他们排序的这些新的值的总和？ ORDER BY（karma_up - karma_down）似乎不工作，我想要什么。

Let's say I have a table with karma_up and karma_down. Everytime someone votes up karma_up gets incremented and everytime someone votes down karma_down gets incremented one as well. How can I pull these a selection of rows and have them ordered by the sum of these new values? ORDER BY (karma_up - karma_down) does not seem to work how I want. I simply want the rows with the highest karma up top.

推荐答案

非常简单

SELECT 
ID, KARMA_UP, KARMA_DOWN, (KARMA_UP-KARMA_DOWN) AS USER_KARMA 
FROM KARMA 
ORDER BY USER_KARMA DESC

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