摘要:
delete from test_table1 a where (a.id,a.cd) in (select id,cd from test_table1 group by id,cd having count(*) > 1) and rowid not in (select min(rowid) 阅读全文
摘要:
获取2022-05-01~2022-05-19内的时间列表 SELECT TO_CHAR(TO_DATE('2022-05-01','YYYY-MM-DD')+ROWNUM-1 ,'YYYY-MM-DD') day_list FROM DUAL CONNECT BY ROWNUM<=trunc(to 阅读全文