已知关系R(A,B,C),其中A和C为数值型属性,试用SQL语句完成下列任务:按属性A分组,求出每组中在属性

参考答案:

CREATE VIEW RVE(ACMAXCMIN)SELECT AMAX(C)MIN(C)ORDER BY ACREATE VIEW RVE(A，CMAX，CMIN)SELECT A，MAX(C)，MIN(C)ORDER BY A