WHERE person_id=1;
A. Show all columns 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 these
Answer:A
WHERE person_id=1;
A. Show all columns 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 these
Explanation: Clause “WHERE” is also used, which tell the compiler to show only that rows which belong to person_id=1.