🎴 Flashcard Mode
Basic SQL Quiz - 2
Card1 / 20
Mastered0
Review0
QuestionClick to flip
With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
AnswerClick to flip back
A
SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
💡 Explanation:
Combine multiple exact-match conditions with AND, using = for each exact value. All matching conditions must be in the WHERE clause, not the SELECT clause. LIKE is unnecessary unless you need pattern matching.