[MySQL] Kaskadovane GROUP BY fce

[frelichl]

SELECT MAX(T.soucet)
FROM (
  SELECT time, SUM(value) as soucet
  FROM table1
  WHERE id = 1 or id = 2
  GROUP BY time) T;

Jenom doufám, že MySQL umí poddotazy ve FROM sekci.