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

6 votes176 views4 answers
Delete table sqlite
SQL
3 votes180 views1 answer
Select sequence oracle
SQL
0 vote176 views1 answer
Oracle exchange partition
SQL
0 vote164 views1 answer
Get server date mysql
SQL
1 vote191 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote176 views1 answer
Selecting from a view SQL
SQL
0 vote171 views1 answer
How to put is null in where in clause
SQL
0 vote158 views1 answer
Generate random & unique mysql string
SQL
0 vote175 views1 answer
Search column name sql
SQL
0 vote186 views1 answer
Postgres list all stored procedures query
SQL