Q27
What will be the output of the following SQL statement? SELECT * FROM person WHERE person_id=1;
A.
Show all columns but only those rows which belongs to person_id=1
AnswerB.
Show all columns and rows
C.
Shows only columns person_id
D.
None of the mentioned
Answer: Option A
Solution
Answer: Option A
Solution:
The given SQL statement is a SELECT query that retrieves data from the "person" table where the "person_id" column equals 1. The WHERE clause filters the rows to only those where person_id=1. Therefore, the query will return all columns, but only the rows where person_id=1. Hence, Option A is correct.