Q. What will be the output of the following SQL statement?
SELECT person_id, fname, lname
FROM person
WHERE person_id=1;
SELECT person_id, fname, lname
FROM person
WHERE person_id=1;
β
Correct Answer: (A)
Show only columns(person_id, fname, lname) but only those rows which belongs to person_id=1
Explanation: This SQL statement is asking the database to show us some information about a specific person. Let's break it down: