Co třeba:

Kód:
SELECT Pid_pracovnik,Datum,SUM(Hodin) FROM Hodiny WHERE Pid_pracovnik = 2 GROUP BY SUBSTRING(Datum FROM 6 FOR 2) ORDER BY Datum;
EDIT: nestihl jsem to ...