PG数据库获取最近四个小时 使用产品的用户审计信息
1. 使用关联子查询
2. 使用时间interval
SELECT 审计表.COUNT, gspuser.code FROM gspuser JOIN ( SELECT gspaudit1912.userid, COUNT ( 1 ) FROM gspaudit1912 WHERE datetime > ( SELECT now() - INTERVAL ‘4 hour‘ ) GROUP BY userid ORDER BY 2 DESC ) 审计表 ON 审计表.userid = gspuser.ID ORDER BY 1 DESC
需要加强学习.. 自己的SQL 还是太弱鸡了.
相关推荐
yangkang 2020-11-09
lbyd0 2020-11-17
sushuanglei 2020-11-12
85477104 2020-11-17
KANSYOUKYOU 2020-11-16
wushengyong 2020-10-28
lizhengjava 2020-11-13
星月情缘 2020-11-13
huangxiaoyun00 2020-11-13
luyong0 2020-11-08
腾讯soso团队 2020-11-06
Apsaravod 2020-11-05
PeterChangyb 2020-11-05
gaobudong 2020-11-04
wwwjun 2020-11-02
gyunwh 2020-11-02
EchoYY 2020-10-31
dingyahui 2020-10-30