Oracel小知识记录 yangan

1、查询重复记录

select * from st_rnfl_r t where (select count(*) from st_rnfl_r s where s.ymdhm = t.ymdhm)>1