我正在嘗試在我的 SQL 資料庫中設定一些監控。
select
gn.Goal_Name_
,gn.EventTimestamp as Timestamp
--,Max(EventTimestamp) as Timestamp
from(
select CASE when substr(GoalName,1,3)='MSD' then 'MSD' when substr(GoalName,1,5)='https' then 'https' else goalname END as Goal_Name_
,EventTimestamp
from CG.Goal as goal
)gn
group by 1,2
生成具有如下結構的表：
| 目標名稱_ | 時間戳 |
|---|---|
| 默沙東 | 05.03.2021 11:05:20.162 |
| 登出 | 18.01.2022 20:07:29.799 |
| 登錄 | 23.01.2022 09:12:16.597 |
| ETC | ETC |
我遇到的問題是找到一種方法來計算每天每個不同的目標名稱。真正找到每天發生的事情。
uj5u.com熱心網友回復：
你快到了。唯一缺少的是將時間戳轉換為日期并計算行數。
select
gn.Goal_Name_
,CAST(gn.EventTimestamp AS DATE FORMAT 'YYYY/MM/DD') as eventDay
,Count(*) as GoalsCount
from(
select CASE when substr(GoalName,1,3)='MSD' then 'MSD' when
substr(GoalName,1,5)='https' then 'https' else goalname END as Goal_Name_
,EventTimestamp
from CG.Goal as goal
)gn
group by 1,2
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/523917.html
標籤：sql兆数据