sql小技巧汇总
1.相同数据仅保留一条,假设有3条相同数据
delete ?tbl_test t ?where t.num = 208 and t.name = '123' and rownum < 3
