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 votes190 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote171 views1 answer
SQL FROM-Klausel
SQL
0 vote181 views1 answer
Hex string sql becomes int64
SQL
0 vote155 views1 answer
Excute raw query
SQL
21 votes167 views1 answer
SQL cheat sheet pdf
SQL
2 votes206 views1 answer
Datetrunc
SQL
0 vote176 views1 answer
Insert using condition postgres
SQL
1 vote179 views2 answers
How to combine 2 tables in MySQL
SQL
3 votes179 views1 answer
Postgres select max value
SQL
0 vote161 views1 answer
Oracle last character of string
SQL