πŸ“Š MySQL
Q. 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) ==
  • (C) Shows only columns person_id
  • (D) None of the mentioned
πŸ’¬ Discuss
βœ… 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:

Explanation by: Priyanka Tomar
This SQL statement is asking the database to show us some information about a specific person. Let's break it down:

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
82
Total Visits
πŸ“½οΈ
12 mo ago
Published
πŸŽ–οΈ
Priyanka Tomar
Publisher
πŸ“ˆ
98%
Success Rate