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 vote153 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
14 votes154 views3 answers
Oracle sql limit results
SQL
3 votes165 views1 answer
Set default today mysql
SQL
0 vote159 views1 answer
Drop table BigQuery table columns
SQL
0 vote146 views1 answer
Sql remove last 2 digit
SQL
0 vote135 views1 answer
Psql datestyle
SQL
3 votes137 views2 answers
Sql add year to date
SQL
0 vote144 views1 answer
Select last N rows mysql
SQL
0 vote141 views1 answer
Db format in quotation
SQL
0 vote153 views1 answer
Mysql custom sort order
SQL