how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"
SELECT * FROM Persons WHERE FirstName='Peter',LastName='Jackson'
SELECT * FROM Persons WHERE FirstName='Peter' OR LastName='Jackson'
SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'