PHWinfo - Afficher un message

18/10/2007, 19h40

I have the following view, and would like to do a group by date to
find out what is the current size of production. I can do the group
by week (dt), but that returns 1 barn 7 times per week, so it sums it
up 7 times. How can I do this group by and use the distinct to have
only one barn per grouping?

ID Barn_ID Size StartDate Received StartDate_p_Life dt
1 1 5000 08/02/2007 1 22/10/2007 10/18/2007
5 2 4000 17/10/2007 1 12/08/2008 10/18/2007
6 3 6000 15/05/2007 1 11/11/2007 10/18/2007
1 1 5000 08/02/2007 1 22/10/2007 10/19/2007
5 2 4000 17/10/2007 1 12/08/2008 10/19/2007
6 3 6000 15/05/2007 1 11/11/2007 10/19/2007
1 1 5000 08/02/2007 1 22/10/2007 10/20/2007
5 2 4000 17/10/2007 1 12/08/2008 10/20/2007
6 3 6000 15/05/2007 1 11/11/2007 10/20/2007

maybe it's not even possible to use the distint - I can't quite figure
it out.

18/10/2007, 19h40	#1
sparky Messages: n/a Hébergeur:	distinct in a group by Date I have the following view, and would like to do a group by date to find out what is the current size of production. I can do the group by week (dt), but that returns 1 barn 7 times per week, so it sums it up 7 times. How can I do this group by and use the distinct to have only one barn per grouping? ID Barn_ID Size StartDate Received StartDate_p_Life dt 1 1 5000 08/02/2007 1 22/10/2007 10/18/2007 5 2 4000 17/10/2007 1 12/08/2008 10/18/2007 6 3 6000 15/05/2007 1 11/11/2007 10/18/2007 1 1 5000 08/02/2007 1 22/10/2007 10/19/2007 5 2 4000 17/10/2007 1 12/08/2008 10/19/2007 6 3 6000 15/05/2007 1 11/11/2007 10/19/2007 1 1 5000 08/02/2007 1 22/10/2007 10/20/2007 5 2 4000 17/10/2007 1 12/08/2008 10/20/2007 6 3 6000 15/05/2007 1 11/11/2007 10/20/2007 maybe it's not even possible to use the distint - I can't quite figure it out.