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 vote332 views1 answer
Cross schema query oracle 2 users
SQL
0 vote327 views1 answer
Mysql select statement after index
SQL
1 vote316 views1 answer
Importance of comment in mysql
SQL
0 vote325 views1 answer
Group_concat only returns one row
SQL
4 votes326 views1 answer
T-sql get duplicate rows
SQL
7 votes329 views2 answers
Add column table pl sql
SQL
1 vote312 views1 answer
Stop mysql server mac
SQL
0 vote347 views1 answer
Create table with primary key and foreign key in sql server
SQL
8 votes349 views1 answer
My sql version
SQL
1 vote336 views1 answer
Woocommerce mysql price table
SQL