Biology Forums - Study Force

Other Fields Homework Help Management Topic started by: Chinnab on Jan 31, 2018



Title: Which type of view is created from the following SQL statement? CREATE VIEW balancedue AS SELECT ...
Post by: Chinnab on Jan 31, 2018
Which type of view is created from the following SQL statement? CREATE VIEW balancedue AS SELECT customer, order, SUM(quantityretail) amtdue FROM customers NATURAL JOIN orders NATURAL JOIN orderitems NATURAL JOIN books GROUP BY customer, order;
 a. simple
  b. complex
   c. inline
  d. partial


Title: Which type of view is created from the following SQL statement? CREATE VIEW balancedue AS SELECT ...
Post by: nopro on Jan 31, 2018
Content hidden