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

0 vote375 views1 answer
Best sql collation
SQL
0 vote375 views1 answer
Tinydb add table
SQL
1 vote370 views1 answer
Update substring in mysql
SQL
0 vote344 views1 answer
Sql server select furst day of current year
SQL
4 votes347 views1 answer
Refresh postgres config
SQL
9 votes347 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote366 views1 answer
How to get nth number in sql
SQL
0 vote365 views1 answer
Sql today at midnight
SQL
1 vote315 views1 answer
Delete triger pl pg sql
SQL
0 vote373 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL