四时宝库

merge into table a using (select count(1) cnt from table ) b on (cnt>1) when matched update set.... when not matched then insert into... values(..)