MySQL Forums
Forum List  »  Newbie

Re: Trouble making formula.
Posted by: Gordon White
Date: May 02, 2016 12:21PM

SELECT b.name, a.points
BETWEEN 1
AND 7 AS pts
FROM data a, players b
WHERE a.playersid = b.playersid
ORDER BY a.points DESC
LIMIT 0 , 7

name pts
Dick 1
Charlie 1
Tammy 1
Gordon 1
Sharon 1
Tammy 1
Dorian 1

Should be

Last Weeks Finish - Weeks played 15
Name Points
Gary 7
Kaileen 6
Shirley 5
Dorian 4
Sharon 3
Vicki 2
Bob 1

Options: ReplyQuote


Subject
Written By
Posted
May 02, 2016 07:26AM
Re: Trouble making formula.
May 02, 2016 12:21PM


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.