MySQL - Abfrage / Sortieren ... immer noch Problem

[Ilja]

yo,

Könnte mir nochmal wer helfen, bitte?

SELECT name, MAX(kontostand) AS kontostand, MAX(datum) AS Datum
FROM $mysql_name_tabelle AS tab1
WHERE datum = (SELECT max(datum) FROM $mysql_name_tabelle AS tab2 WHERE tab2.name = tab1.name)
GROUP BY n1
ORDER BY kontostand desc, datum desc
LIMIT 0,10

Ilja