With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” is “Peter”?

Here is the answer for the question – With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” is “Peter”?. You’ll find the correct answer below

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” is “Peter”?
SELECT * FROM Persons WHERE FirstName<>‘Peter’
SELECT * FROM Persons WHERE FirstName=’Peter’
SELECT [all] FROM Persons Where FirstName Like ‘Peter’
SELECT [all] FROM Persons Where FirstName = ‘Peter’

The Correct Answer is

SELECT * FROM Persons WHERE FirstName=’Peter’

Reason Explained

SELECT * FROM Persons WHERE FirstName=’Peter’ is correct for With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” is “Peter”?

Thankyou for using answerout. We hope you get all your answers here. If you have any special questions, you can comment to ask us.

See also  FEMA IS 156: Building Design for Homeland Security for Continuity of Operations Answers

Leave a Comment