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

2 votes157 views1 answer
Mysql select default if null
SQL
1 vote142 views3 answers
Execute sp in sql server
SQL
1 vote134 views1 answer
Sql alchemy with azuresql server
SQL
5 votes151 views1 answer
Sort order on two columns sql
SQL
0 vote158 views1 answer
Postgresql log
SQL
0 vote163 views1 answer
Sql injection payload list github
SQL
14 votes158 views3 answers
How to add default constraint in mysql
SQL
6 votes154 views2 answers
Where clause in sql
SQL
-2 votes154 views1 answer
Modify column name in tsql
SQL
0 vote147 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL