List players by numbers of points?

alexfr · #1 (**permalink**) 05-23-2006, 11:34 PM

List players by numbers of points (descending, so the best is at the top) and from oldest to youngest (if 2 players have same number of points, the oldest would be first).

alexfr · #2 (**permalink**) 05-24-2006, 12:02 AM

SELECT p.lastname, p.firstname, SUM(r.value) AS Total, MAX( r.value) AS Maximum, p.birthdate 

FROM player p INNER JOIN Resuls r ON p.id_player = r.id_player 

GROUP BY p.lastname, p.firstname, p.birthdate , p.id_player ORDER BY Total DESC, Maximum DESC, birthdate ASC

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

User Name		Remember Me?
Password

List players by numbers of points?

ANSWER(S):