Injae's Laboratory
Back to list

Query : Delete except one

Injae 03 Mar 2015, 10:51 1387 views 0
delete from tblblogfeed where tid not in(select min(tid) from tblblogfeed group by actuallink)
delete from tblnewsfeed where tid not in(select min(tid) from tblnewsfeed group by originallink)