MySQL Forums
Forum List  »  German

Re: ORDER BY nach Punkten....
Posted by: Thomas Wiedmann
Date: September 09, 2012 11:21PM

kleine Korrektur in der ORDER BY, da ich denke, dass die Anzahl der Punkte SUM_POINTS wichtiger sind, als die Anzahl der Dreier SUM_DREIER.

SELECT u.user_id, 
       MAX(u.username) AS username,
       SUM(t.points) AS sum_points,
       SUM( CASE 
                WHEN t.points = 3 THEN 1
                ELSE 0
               END 
          ) AS sum_dreier       
  FROM users u
  JOIN tipps t
    ON t.user_id = u.user_id
GROUP BY u.user_id
ORDER BY sum_points DESC, sum_dreier DESC , u.username;
+---------+----------+------------+------------+
| user_id | username | sum_points | sum_dreier |
+---------+----------+------------+------------+
|       1 | User-1   |          5 |          1 |
|       2 | User-2   |          5 |          0 |
+---------+----------+------------+------------+
2 rows in set (0.25 sec)

mysql>

Grüße
Thomas

Options: ReplyQuote


Subject
Views
Written By
Posted
1653
September 09, 2012 10:20AM
952
September 09, 2012 12:31PM
Re: ORDER BY nach Punkten....
1055
September 09, 2012 11:21PM
761
September 10, 2012 08:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.