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 vote104 views1 answer
Postgresql escape single quote
SQL
1 vote107 views1 answer
Mysql sort by date column
SQL
2 votes121 views1 answer
Sql get the name of user pc
SQL
0 vote91 views1 answer
Alter table add foreign key mariadb example
SQL
8 votes97 views1 answer
How to remove tables from postgresql
SQL
0 vote114 views1 answer
Mysql get nth highest
SQL
3 votes118 views1 answer
Export postgres database linux
SQL
0 vote88 views1 answer
Knex last insert id mysql
SQL
24 votes106 views4 answers
Postgres delete database
SQL
1 vote63 views1 answer
Mysql show attributes of a table
SQL