Am Monday, March 17, 2003 4:39 PM [GMT+1Std. Beckstown-Time],
hieb Hoffmann Thorsten <[EMAIL PROTECTED]> in die Tasten :

> Hallo Liste,
> 
> ich habe eine Tabelle mit folgenden Feldern:
> 
> benutzer_id
> rennen_id
> punkte


SELECT 
Max(benutzer_id) AS Name,
Max(rennen_id) AS Rennen,
SUM(punkte) AS PktSumme,
FROM tabelle
GROUP BY benutzer_id
ORDER BY PktSumme, Name

*ungetestet*

Frank
~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~
Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular
ATTACK! Download Intrexx CRM-Studio Now!   http://www.intrexx.com
_______________________________________________
Database.asp mailing list
[EMAIL PROTECTED]
http://www.glengamoi.com/mailman/listinfo/database.asp

Antwort per Email an