Add week ending date sql server

SELECT  
    DATEADD(DAY, 7 - DATEPART(WEEKDAY, orderDate), CAST(orderDate AS DATE)) AS ordersPerWeek, 
    sum(orderAmount) AS orderSumForGrouping, 
    count(1) AS numberOfOrdersWithinGrouping
FROM    @table o
GROUP   BY DATEADD(DAY, 7 - DATEPART(WEEKDAY, orderDate), CAST(orderDate AS DATE))

Source: stackoverflow.com

Similar codes

1 vote163 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
11 votes155 views6 answers
Distinct sql
SQL
1 vote157 views1 answer
Count mysql server db tables
SQL
5 votes149 views2 answers
Postgres update with if condition query
SQL
1 vote175 views1 answer
How do you use sql in you company
SQL
2 votes146 views2 answers
Sqlalchemy filter or
SQL
6 votes150 views1 answer
What is where clause in sql
SQL
7 votes148 views4 answers
What is my mysql version
SQL
6 votes186 views2 answers
WHERE value IS sql
SQL
0 vote147 views1 answer
Create table sql generator
SQL