Sql

Search

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))

Comment

PREVIOUS	NEXT

Code Example
Sql :: select odd records sql
Sql :: sql server version check
Sql :: dbms_metadata.get_ddl table
Sql :: smallint sql
Sql :: postgresql backup and restore globals and data
Sql :: mssql procedure
Sql :: SQL Error [42501]: ERROR: permission denied for table
Sql :: sql alter column name sql server
Sql :: mysql function to remove multiple spaces from the string
Sql :: sql if null then string
Sql :: call function in query sql server
Sql :: sql insert into select
Sql :: execut sql python
Sql :: implode in sql query
Sql :: on sql table data exists
Sql :: how to check user grant in mysql
Sql :: postgresql select case insensitive
Sql :: mariadb create view
Sql :: make parameters nullable in sql server
Sql :: sql insert into statement
Sql :: what is cursor in sql server with example
Sql :: how to put is null in where in clause
Sql :: mysql order by on condition
Sql :: sql comments
Sql :: sqlite clear console
Sql :: faire la différence entre deux tables sql big query
Sql :: time in sql server
Sql :: oracle list partitioned tables
Sql :: postgres show table schema
Sql :: drop domain postgresql

Search

SQL

add week ending date sql server

ADD CONTENT