4.1ʹinsert䡶ѧϵͳݿѧһ¼
	INSERT INTO student
	VALUES ( 40101,桯,С,1985-5-15,,z0401,2004-9-1,h1101, кӶ·8š, 13520201187)
4.2ѧУԱĬֵΪСôʹinsertѧӼ¼ʱʹĬֵ䵽Ա
	INSERT INTO student
	VALUES ( 40101,桯,default,1985-5-15,,z0401,2004-9-1,h1101, кӶ·8š, 13520201187)
4.3ʹinsert벿ݡ
	INSERT INTO studentsID,sname,ssex,sbirthday,szhuanye,sbanji,sruxueshijian,ssushe
	VALUES ( 40101,桯,С,1985-5-15,,z0401,2004-9-1,h1101)
4.4ʹupdateе
	update grade
	set gradenum=gradenum+5
	go
4.5ʹupdate²ݡ
	UPDATE student
	STEsBanji= z0402
	Where  sID=040101
4.6ʹdeleteɾѧѧΪ040101ѧϢ
	DELETEstudent
	WHERE  sID= 040101
4.7ʹdeleteɾѧѧϢ
	DELETEstudent
4.8ʹselectѧвѯѧѧţԱϢ
	Select  ѧ,,Ա
	From  ѧ
4.9ʹͨѡС
	Select * 
	From student
4.10ڽΪ
	Select ѧ=sid=snameԱ=ssex=sbrithday
	From student
	 
	Select sid as ѧţsname as ssex as Աsbrithday as 
	From student
4.11ѧֻǰϡƶ绰˵С
	Select sid,sname,ssex,szhuanye,saddr,ƶ绰:,stel
	From student
4.12ѯѧϢ
	Select sid,kcid,gradenum
	From grade
	Where gradenum<60
4.13ѧУѯѧΪ040108ѧϢ
	Select * 
	From student
	Where sid=040108
4.14ʹbetweenؼֲѯݣѯɼгɼ70-90֮ѧѧšγ̺źͳɼ7090֣
	select sid,kcid,gradenum
	from grade
	where gradenum between 70 and 90
4.15ѧУѯרҵΪϢѧϢַʵ֣ұȽδ롣
	Select *   From  student   Where  szhuanye  in Ϣ
	Select *   From  student   Where  szhuanye =or szhuanye =Ϣ
4.16ʹnullؼֲѯݣϢУѯ᳤ΪֵŵϢ
	Select  *   From  hostel   Where  hosshezhang  is null
4.17ѯѧУѯרҵΪԱΪСѧϢ
	Select  *   From  student   Where  szhuanye= and ssex=С
4.18ģѯѧвҼסеѧϢ
	Select  *   From  student   Where  saddr  like  %
4.19ڿγϢвѯкСԭĿγ̵Ϣ
	Select  *   From  course   Where  kcname  like  %ԭ%
4.20ѯѧרҵϢ
	Select  szhuanye   from  student
4.21ϸнظС
	Select  distinct  szhuanye   from  student
