sql-例子

sql

分组查询,多个字段联合是否包含重复

select count(*),MESSAGE_CODE,MESSAGE_CREATE_TIME,MESSAGE_INFO from GLOBAL_MESSAGE_INFO group by MESSAGE_CODE,MESSAGE_CREATE_TIME,MESSAGE_INFO having count(*)>1 

根据时间点查询记录

select * from GLOBAL_MESSAGE_INFO where MESSAGE_CODE='ac6e0acc04906081' and MESSAGE_CREATE_TIME=to_date('2021-05-14 13:32:16' , 'yyyy-mm-dd hh24:mi:ss')