SQL Server 2014 - How to group by date only from a datetime column
I have a table that lists data every 15 minutes. So my date column data is like '2017-04-18 00:15:00.000' I'm trying to get sum of those columns for that entire day but my grouping doesn't want to work. SELECT Sum(Field 1), Sum(Field 2), Sum(Field 3) FROM MyTable WHERE StartDate >= '2017-04-18' AND StartDate <= '2017-04-19' GROUP BY CAST(StartDate AS DATE) --GROUP BY CONVERT(CHAR(10),StartDate,103) --GROUP BY StartDate The GROUP BY StartDate gives me records like so: 2017-04-18 08:00:00.000 13 3 22 0 2017-04-18 08:15:00.000 15 1 16 0 2017-04-18 08:30:00.000 14 7 13 0 2017-04-18 08:45:00.000 16 3 18 0 2017-04-18 09:00:00.000 17 4 21 0 I've tried: GROUP BY CAST(StartDate AS DATE) as well as GROUP BY CONVERT(CHAR(10), StartDate, 103) These above two group by clauses give me the same error message: The column 'StartDate' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. How would I GROUP by Date so that I can GROUP the data by date as '2017-04-18'
You can try a query like below SELECT CAST(StartDate AS DATE) as S ,Sum(Field 1) ,Sum(Field 2) ,Sum(Field 3) FROM MyTable WHERE StartDate >= '2017-04-18' AND StartDate <= '2017-04-19' GROUP BY CAST(StartDate AS DATE)
How to create partition scheme using partition function?
SQL Server detected a logical consistency-based I/O error
Difference between RDBMS and ORDBMS
Convert columns to rows in SQL Server 2008 and insert into new column [duplicate]
Is there a need of SQL server installed on Local for SSAS projects
MS SQL DateTime value is different in a non-dbo schema
Selecting everything from table with two innner joins and grouping by
I have a table and the strings in that table should be split as shown in the description [closed]
How split a string a string based on position in SQL Server
What does two return statements inside an SQL function mean?
SQL insert #TEMP table
SQL Server trigger for multiple rows
Powershell CSV to SQL Query
Is there any way to connect Oracle DBLink with SQL Server AAG Read Intent (Read Only)
How to compare the value of a column with multiple other column values
How to write a stored procedure in SQL Server to change the columns value after a specific time