A

Admin • 833K Points
Coach

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
  • Correct Answer - Option(A)
  • Views: 22
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

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.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.