-
查询时间段内只有最高级地账户
select 'tb_fsmst_rsacct_0016' as table_name,
cashmgmt_contr_o
from tb_fsmst_rsacct_0016
where create_stamp>'2023-08-10 09:00:00' and create_stamp<'2023-08-10 10:36:00'
group by cashmgmt_contr_o having count(*)=1
select 'tb_fsmst_rsacct_0016' as table_name,
cashmgmt_contr_o
from tb_fsmst_rsacct_0016
where create_stamp>'2023-08-10 09:00:00' and create_stamp<'2023-08-10 10:36:00'
group by cashmgmt_contr_o having count(*)=1