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 vote359 views1 answer
Redshift running queries
SQL
0 vote309 views1 answer
Trigger vérifier stock
SQL
-1 vote309 views3 answers
MySQL shutdown unexpectedly
SQL
0 vote295 views1 answer
Sql file in postgres with pgadmin
SQL
-1 vote284 views1 answer
What is in operator
SQL
2 votes339 views1 answer
Sql compare strings
SQL
0 vote321 views2 answers
Coursera spark sql max count
SQL
0 vote321 views1 answer
Creating sqeuence in oracle database
SQL
1 vote424 views3 answers
Uninstall postgresql mac
SQL
0 vote318 views1 answer
Sql server synonym
SQL