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