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 vote269 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote217 views1 answer
What is mysql_pconnect
SQL
1 vote216 views1 answer
Search for tables with name postgresql
SQL
0 vote230 views1 answer
Mysql not defined
SQL
0 vote225 views1 answer
Postgres in operator with comma separated values
SQL
0 vote243 views1 answer
Add mysql database to power bi web
SQL
0 vote235 views1 answer
MySQL get all previous date record
SQL
0 vote228 views1 answer
Cross apply top for each row t1
SQL
2 votes232 views1 answer
Add default sql server
SQL
0 vote219 views1 answer
Query on date sqlite flutter
SQL