Group data weekly

[depistol]

Hello,

I have a question. I want to pull data from 6 months back from all the employees and see who had more than 60 hours per week during the past 6 months.

So if an employee had more than 60 hours in only one week in the past 6 months, then I would need his name to show up in the query.

Is there a 'group/display per week' function in mySQL?

THanks
Depistol

 

[feherke]

Hi

[b]select[/b]
employee,min(work_day) [b]as[/b] week_start,max(work_day) [b]as[/b] week_end sum(worked_hour)

[b]from[/b] work_table

[b]where[/b] work_day>subdate(curdate(),6*30.5)

[b]group by[/b] employee,date_format(work_day,[i]"%U"[/i])

[b]having[/b] sum(worked_hour)>60;

Feherke.

http://rootshell.be/~feherke/

 

[feherke]

Hi

Oops, missing comma ( , ).

[b]select[/b]
employee,min(work_day) [b]as[/b] week_start,max(work_day) [b]as[/b] week_end[red],[/red] sum(worked_hour)

[b]from[/b] work_table

[b]where[/b] work_day>subdate(curdate(),6*30.5)

[b]group by[/b] employee,date_format(work_day,[i]"%U"[/i])

[b]having[/b] sum(worked_hour)>60;

Feherke.

http://rootshell.be/~feherke/