sql实例---02

/*创建视图*/
create view viewname as select * from test01 where 生日 like '%6%'
/*删除视图*/
drop view viewname
/*修改数据库*/
update test01 set 年龄=86 where 年龄 like '%4%'
update test01 set 姓名='小明' where 姓名='王生'
/*删除指定内容*/
delete from test01 where 姓名='小明'
/*按顺序查询*/
select * from test01 order by 年龄
select * from test01 order by 生日
/*统计总数*/
select count(生日) as totalcount from test01
select count(年龄) as totalcount from test01
/*统计总和*/
select sum(序号) as sumvalue from test01
select sum(年龄) as sumvalue from test01
/*计算平均值*/
select avg(年龄) as avgvalue from test01
/*最大值*/
select max(年龄) as maxvalue from test01
/*最小值*/
select min(成绩) as minvalue from test01
/*复制表*/
select * into test02 from test01
select * into test02 from test01 where 年龄 like '%6%'
select top 3 * into test02 from test01
select * from test02
insert into test02(序号,姓名,年龄) select 序号,姓名,年龄 from test01