Grouping records per week in SQL

I am trying to run a query to pull records per week in a year.

COuld you help create a query?.

I am using 2008 SQL.

Thanks, Ravi

Answers


If you want to aggregate results by week in a single year, then aggregate and group with

GROUP BY DATEPART(wk, <yourDate>), DATEPART(mm, <yourDate>)

Need Your Help

List of people who liked my page

facebook facebook-graph-api facebook-javascript-sdk

Is that possible to know the list of people, who liked my page using Facebook Graph API call? If so - which one call is needed and which persmissions I should request?

Is there more to HTML forms than http://www.w3schools.com/html/html_forms.asp?

html forms webforms

I am creating a form designer. It will generate PHP code which will produce an HTML form. Users will fill in fields and the PHP will store user input in a MySql database (and, of course, they can u...