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 vote171 views1 answer
Select last 2 characters sql
SQL
2 votes163 views1 answer
Sqlplus clear screen
SQL
1 vote196 views2 answers
Oracle leftmost characters
SQL
22 votes283 views4 answers
Mysql date format
SQL
0 vote165 views1 answer
Inner joint
SQL
0 vote189 views1 answer
Least spark sql
SQL
0 vote216 views1 answer
Pl sql round
SQL
0 vote163 views1 answer
Oracle query archive mode
SQL
0 vote168 views1 answer
Authentication in sql server
SQL
0 vote166 views1 answer
Ms sql unique
SQL