Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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