数据库系统07--编辑维护表格数据.ppt

例题程序1：显示含有本年度截止到现在的当前销售额的行，然后按type以递减顺序计算书籍的平均价格和预付款总额. USE pubs SELECT CAST(title AS char(20)) AS title, type, price, advance FROM titles WHERE ytd_sales IS NOT NULL ORDER BY type DESC COMPUTE AVG(price), SUM(advance) BY type COMPUTE SUM(price), SUM(advance) 例题程序2：先删除表T1，然后又创建一个带有四个列的表T1.最后利用INSERT 语句插入一些数据行，这些行只有部分列包含值. IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = T1) DROP TABLE T1 GO CREATE TABLE T1 ( column_1 int identity, column_2 varchar(30) CONSTRAINT default_name DEFAULT (column default), column_3 int NULL, column_4 varchar