;nest" should be "best" :)
- Original Message -
From: "Richard Clarke" <[EMAIL PROTECTED]>
To: "Richard Clarke" <[EMAIL PROTECTED]>; "Anzej Becan"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 11, 2002 6:3
I have table "users" with some results. Now I would like to sum up highest
two points (not all!) for each user and sort by this sum.
If I use this sql query...
SELECT user, SUM(points) total FROM users GROUP BY user ORDER BY total
desc;
... the result is sum of all points for each user.
How to su
