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

20 votes134 views3 answers
SQL query rename table
SQL
2 votes143 views2 answers
Sql lag
SQL
0 vote137 views2 answers
Zsh: command not found: mysq
SQL
0 vote132 views1 answer
Order by with where clause in mysql
SQL
1 vote136 views1 answer
Sql get missing id
SQL
0 vote126 views1 answer
Oracle search columns in schema
SQL
0 vote151 views1 answer
Order child below the parent in mysqli
SQL
0 vote127 views1 answer
Cast for print sql
SQL
0 vote137 views1 answer
Python connect microsoft sql server
SQL
2 votes124 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL