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 vote127 views1 answer
Cast as decimal postgresql
SQL
5 votes123 views1 answer
Sql check if date is between 2 dates
SQL
57 votes291 views6 answers
Mysql alter table add column
SQL
0 vote120 views1 answer
Sql pivot without aggregate
SQL
12 votes133 views4 answers
Psql command not found
SQL
0 vote125 views1 answer
Plpgsql raise notice
SQL
10 votes109 views3 answers
Join multiple tables sql
SQL
0 vote125 views1 answer
How to install sql in anaconda
SQL
-1 vote135 views1 answer
MYSQL stored procedure select from
SQL
5 votes145 views6 answers
Sql foreign key
SQL