Injae's Laboratory
My Tech Choices
Title
Query : Delete except one
Writer
Injae
Date
3/03/2015 10:51:01 AM
View
1332
Up
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)
delete from tblnewsfeed where tid not in(select min(tid) from tblnewsfeed group by originallink)