Converting SQL delete statement to Core Data
Converting SQL delete statement to Core Data
- Subject: Converting SQL delete statement to Core Data
- From: Laurent Daudelin <email@hidden>
- Date: Tue, 21 Jul 2015 11:28:51 -0400
Since there is no Core Data specific list, I thought I would ask here.
I'm trying to convert the following SQL statement to Core Data:
delete from SomeTable
where someID not in (select someID from SomeTable group by
property1, property2, property3)
Basically, I want to retrieve and delete possible duplicates in a table
where a record is deemed a duplicate if property1, property2 and property3
are equal to another record.
How can I do that?
Thanks in advance!
-Laurent.
--
Laurent Daudelin email@hidden
AIM/iChat/Skype:*LaurentDaudelin* http://www.nemesys-soft.com/
Logiciels Nemesys Software
_______________________________________________
Cocoa-dev mailing list (email@hidden)
Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden