今天很蠢,正式环境的数据删除前忘记备份数据,尴尬至极......
终于找到一个半个小时内可以查到删掉的数据(即使已提交)
不多说,上sql
select * from ( select * from T_PYFA_GRKCSQ where grpyjhsq_id in ('S2109071002420212021_090_01_071000090031433632912656744448')) as of timestamp to_timestamp('2021-09-05 13:11:40','yyyy-mm-dd hh24:mi:ss')