网站介绍:关于PostgreSQL数据库分组查询时,跟mysql还是有区别的。纠结了半SELECT prjnumber, zjhm,-- to_char ( to_timestamp ( kqsj / 1000 ), 'yyyy-MM-dd HH24:MI:SS' ) kqsj, kqflag, workername, max(kqsj) -- workertype,-- tpcodename,-- isactive FROM GB_CLOCKINGIN WHERE kqsj
- 链接地址:https://blog.csdn.net/qq_34377273/article/details/107564372
- 链接标题:PostgreSQL的GROUP BY问题-CSDN博客
- 所属网站:blog.csdn.net
- 被收藏次数:9548
- 网站标签:PostgreSQL的GROUP BY问题