7 lines
218 B
SQL
7 lines
218 B
SQL
USE sandbox
|
|
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
|
|
|
|
SELECT CAST([LogDateTime] AS DATE) AS [day], COUNT(1) AS cnt
|
|
FROM [cds_log]
|
|
GROUP BY CAST([LogDateTime] AS DATE)
|
|
ORDER BY CAST([LogDateTime] AS DATE) DESC |