List:General Discussion« Previous MessageNext Message »
From:Richard Reina Date:April 19 2013 2:24pm
Subject:Query Help
View as plain text  
Hello All,

Happy Friday! I know how to do the following query:

>select count(*) from sales where WEEK(sale_date)=15 AND
YEAR(sale_date)=2013;

But can someone tell me I can do a query that will give me:

the count(*) for each week of 2013 so that I end up with:

WEEK | COUNT
1           | 22
2           | 31
3           | 29
etc...

Thanks,

Richard

Thread
Query HelpRichard Reina19 Apr
  • RE: Query HelpIlya Kazakevich19 Apr
  • Re: Query HelpLarry Martell19 Apr
    • Re: Query HelpRichard Reina19 Apr