01
T-SQL案例整理
已知有一个表:该表的字段有:id,name,date,gradeid,email,表名为table_name,按要求实现下面内容。
1.插入一条记录:
insert into table_name values (1,'刘世豪','2017-10-21',1,'666@qq.com')
2.将学号是1的学生姓名修改成张云飞
update table_name set name = '张云飞' where id =1
3.删除编号为1的学生信息
delete from table_name where id = 1
4.查询全部信息
select * from table_name
5.查询姓名是刘世豪的学生信息
select * from table_name where name ='刘世豪'
6.查询姓名中姓孙的学生信息
select * from table_name where name like '孙%'
7.查询姓名中包含华的
select * from table_name where name like '%华%'
8.按照年级编号升序排序
select * from table_name order by gradeid asc
9.按照年级编号降序排序
select * from table_name order by gradeid desc
10.查询每个年级多少人
select count(*) 人数,gradeid 年极 from table_name group by gradeid
11.查询前20条信息
select top 20 * from table_name
12.查询百分之20的数据
select top 20 percent * from table_na