Q. Find the missing clause from the following SQL statement?
CREATE VIEW person_1 AS
SELECT fname, lname, person_id
_________ person;

  • (A) FROM
  • (B) same
  • (C) SELECT
  • (D) None of the mentioned
💬 Discuss
✅ Correct Answer: (A) FROM
Explanation: FROM: In SQL, the FROM clause is used to specify the table or tables from which data will be selected. In this context, the FROM clause is required to indicate the source table (person) from which the columns fname, lname, and person_id are selected.

Published by Ritu Nagar ⭐ 4.39K Points at 22-Mar-2025 12:41 pm in MySQL

Explanation by: Ritu Nagar
FROM: In SQL, the FROM clause is used to specify the table or tables from which data will be selected. In this context, the FROM clause is required to indicate the source table (person) from which the columns fname, lname, and person_id are selected.

💬 Discussion

📊 Question Analytics

👁️
88
Total Visits
📽️
1 y ago
Published
🎖️
Ritu Nagar
Publisher
📈
94%
Success Rate