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 vote157 views1 answer
Sqlite referential integrity
SQL
11 votes145 views2 answers
Insert date sql
SQL
0 vote177 views1 answer
Into operator in sql
SQL
12 votes157 views1 answer
How to change the value of a table in sql
SQL
0 vote188 views1 answer
Sql query to find percentage of null values in a table
SQL
1 vote144 views1 answer
PLS-00225 type
SQL
-1 vote110 views2 answers
On delete set default sql server
SQL
4 votes150 views1 answer
SQL order random
SQL
12 votes166 views1 answer
Psql drop column
SQL
8 votes181 views1 answer
My sql version
SQL