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

1 vote156 views1 answer
Sql select contem uma palavra
SQL
1 vote136 views1 answer
How to delete record sql delphi
SQL
0 vote147 views1 answer
Where name ends in SQL
SQL
0 vote148 views1 answer
Sql check if column exists
SQL
0 vote148 views1 answer
Storing RGBA in mysql db
SQL
0 vote154 views1 answer
Select year from dual oracle
SQL
57 votes338 views6 answers
Sql alter table
SQL
0 vote126 views1 answer
Duplicate foreign key constraint name
SQL
1 vote157 views1 answer
Postgres format date in select
SQL
3 votes132 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL