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

2 votes193 views1 answer
Mysql find tables with name
SQL
0 vote239 views1 answer
MySQL get all previous date record
SQL
14 votes208 views2 answers
Oracle export trigger ddl
SQL
4 votes215 views2 answers
Select first and last row mysql
SQL
16 votes209 views6 answers
Install sqlite3 python
SQL
0 vote226 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote210 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
2 votes199 views1 answer
Mysql increment value by 1 in update
SQL
3 votes250 views1 answer
Postgres update column with value from another table
SQL
1 vote216 views1 answer
Mysql add fields
SQL