Que: What will be the output of the following SQL statement?

SELECT person_id, fname, lname
FROM person
WHERE person_id=1;
a. Show only columns(person_id, fname, lname) but only those rows which belongs to person_id=1
b. Show all columns and rows
c. Shows only columns person_id
d. None of the mentioned
Answer: Show only columns(person_id, fname, lname) but only those rows which belongs to person_id=1

Leave a Comment