1、mysql按时间去除重复、获取最新记录
SELECT
f.guid,
f.ch_keyword,
f.patent_guid,
f.create_date
FROM
( SELECT b.patent_guid, MAX(b.create_date ) AS create_date FROM MGSRMS.T_KYZL_RETRIEVE b GROUP BY b.patent_guid ) b
INNER JOIN MGSRMS.T_KYZL_RETRIEVE f ON f.patent_guid = b.patent_guid AND f.create_date = b.create_date
2、锁表解锁
对表进行任何操作都不被允许,提示SQLSTATE=57016 SQLCODE=-668 ,原因码 "7"的错误:SQL0668N Operation not allowed for reason code “7” on table XXX. 解决方法为:
执行命令:
执行 CALL SYSPROC.ADMIN_CMD(‘reorg table XXXXXXX’)
mysql按时间去除重复、获取最新记录 锁表解锁
最新推荐文章于 2024-04-12 18:21:38 发布