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 vote191 views2 answers
Sqlalchemy core in clause
SQL
0 vote184 views1 answer
Mysql wsrep ls
SQL
0 vote231 views1 answer
Hibernate dialect property xml for mysql 8
SQL
4 votes175 views1 answer
Mysql ip address
SQL
2 votes142 views1 answer
Select sid oracle
SQL
1 vote187 views2 answers
Insert sqlite
SQL
0 vote202 views1 answer
Oracle winter time change
SQL
0 vote193 views1 answer
Code to move ietms from one table to another myswl
SQL
0 vote207 views1 answer
Sql cursor example multiple columns
SQL
9 votes179 views6 answers
Sql add column with default value
SQL