Re: Trouble making formula.
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
Subject
Written By
Posted
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.