2009/5/18 Dani Castaños <dcasta...@androme.es> > Hi again, > > I need to extract date grouped by week from an statistics table. > > I was trying something like this: > > SELECT total_duration, EXTRACT( week from date statistics_date ) > FROM statistics_daily > GROUP BY EXTRACT( week from date statistics_date ), total_duration; > > But it doesn't works... Neither: > > SELECT total_duration, statistics_date > FROM statistics_daily > GROUP BY EXTRACT( day from statistics_date ), total_duration, > statistics_date; > > hmmm.. it's not clear what do you want.
why not just something like SELECT EXTRACT( week from statistics_date ) as week, SUM( total_duration) as total_duration_sum FROM statistics_daily GROUP BY 1; ? -- Filip Rembiałkowski JID,mailto:filip.rembialkow...@gmail.com http://filip.rembialkowski.net/
