Question

With sql, how do you select all the records from a table named "persons" where the "firstname" is "peter" and the "lastname" is "jackson"?

Answer 1

select * from persons

where firstname="Peter"

and

lastname ="Jackson";

Answer 2

$\star\:\:\:\sf\large\underline\blue{Question:-}$

Write the SQL code to select all the records from a table named "persons" where "firstname" is "peter" and the "lastname" is "jackson"?

$\star\:\:\:\sf\large\underline\blue{Answer:-}$

So, here is the SQL code for the question.

SELECT * FROM persons WHERE FirstName="peter" AND LastName="jackson"