sql小技巧汇总

1.相同数据仅保留一条,假设有3条相同数据

delete ?tbl_test t ?where t.num = 208 and t.name = '123' and rownum < 3