A.
SELECT 药品编号,SUM(数量*单价) AS 销售总价; FROM MXB INTO VIEW YP
B.
CREATE VIEW YP AS; SELECT 药品编号,SUM(数量*单价) AS 销售总价; FROM MXB; GROUP BY 药品编号
C.
CREATE VIEW YP AS; SELECT 药品编号,SUM(数量*单价) AS 销售总价; FROM MXB; ORDER BY 药品编号
D.
CREATE YP AS VIEW; SELECT 药品编号,SUM(数量*单价) AS 销售总价; FROM MXB; ORDER BY 药品编号