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 vote230 views1 answer
Alter check command
SQL
2 votes222 views1 answer
Add default sql server
SQL
0 vote268 views1 answer
Postgres rename database
SQL
1 vote208 views1 answer
Oracle grant on all tables in schema
SQL
0 vote225 views1 answer
How to select all fieldsin a soql query
SQL
0 vote223 views1 answer
Mysql multiple count
SQL
2 votes217 views1 answer
Oracle current date without time
SQL
2 votes218 views2 answers
Select list is not in group by clause
SQL
1 vote239 views1 answer
Mysql curdate between two dates
SQL
0 vote246 views2 answers
How to drop mili second in sql
SQL