Quote:
Suppose the table has Only 3 fields . FirstName, MiddleName and LastName. And there are 1000 records and i want to delete last 10 records. Then how to delete them
Then you will have to get a determinant for your "last 10 records" statement.
If you do not have any field than can discriminate the last record (from a sequence number, or a datetime for example), then you have to find some sort of criteria. From the informations you gave us, the only criteria I can imagine is an alphabetical one.
If you really need to delete the "last 10 inserted records", then you should include a column in your table that will serve as a discriminant.
If you do not have such a column, then you will only be able to sort on text fields. And if you do not sort the records before deleting the first 10 of them, then you will delete 10 random records.
Important thing here is you should have a field in your table that will be able to discriminate the "last 10 records".
Hope this helps.