How can i create a unique constraint for two fields in a table? That is, the two fields together must be unique.
For example Firstname, Surname
I can have James Mark,James Sun, and James Joe,in the records.But not James Mark and another James Mark.
Also, there is an integer field called point.
The records look like this:James Mark 10,James Sun 12,James Joe 5,Martin Whie 2
How can i count all points for a particular firstname?
For example how can i count all points for the firstname “James”
How can i delete all records for a particular Firstname?