数据库——使用语句.docVIP

select * from student where ssex=男 select sno 学号,sname 姓名 from student select sname + ssex 姓名性别 from student select * from student insert into student(sno,sname,ssex) values(118,王斌太郎,男) select * from student where class is null select * from student where class is not null select top 3 * from student select top 3 * from student order by sno desc select top 30 percent * from student select * from student order by sname desc select * from score order by degree desc select * from score order by cno desc,degree desc select charindex(a,bbaggd,1) select len(andce)