PostgreSQL的GROUP BY问题-CSDN博客

网站介绍:关于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