Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
villegasi03
Creator
Creator

Grouping by a Timestamps Date in SQL statement

I am hoping that this will be an easy question to answer. I am trying to group some data from a SQL table by date but the table only contains a timestamp.

Below is an example of my script:

LOAD

     ID,

     EmployeeCt;

SQL Select

     ID,

     Timestamp,

     COUNT(Employee) AS EmployeeCt

FROM dbo.Employees

GROUP By ??????;

Any help would be much appreciated. Thank you

0 Replies