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

16 votes377 views1 answer
Mssql int max value
SQL
4 votes374 views4 answers
What is primary key
SQL
0 vote347 views1 answer
Varchar format not case sensitive sql
SQL
0 vote366 views1 answer
Sql file in postgres with pgadmin
SQL
2 votes355 views4 answers
Mysql select into new table
SQL
0 vote382 views2 answers
Create row number in sql
SQL
1 vote322 views1 answer
Select random sample sql
SQL
5 votes346 views3 answers
Mysql extract month from date
SQL
3 votes335 views1 answer
Oracle detect invalid password
SQL
2 votes316 views1 answer
Oracle sql drop column if exists
SQL