How to delete records from a table in pure SQL?
Posted on 2013-01-21
I have been playing around with the insert statement in my SQL, i looked at my table and noticed that i have got 8 records for one person and 8 records for another person both of whom i used the insert statement for numerous times, obviously i only want one record for each person.
I tried to use logic, and tried DELETE * FROM Person WHERE FirstName = 'Jack Lumsdon'
DELETE * FROM Person WHERE FirstName IS =('Jack Lumsdon')
But to no avail. I get a red squiggly line underneath the * and the error message Incorrect syntax '*'.
Any ideas of how i can get my table to delete these and bring me back down to just one record for each person.