qq_45879986的博客

SQL练习2 4.1查有成绩的学生信息 select *from student where student.sid in(select DISTINCT sc.sid from sc); 5.查询「白」姓老师的数量 select count(*) from teacher where teacher.tname like’白%’; 6.查询学过「张三」老师授课的同学的信息 select * from student,SC where(student.sid=SC.sid and sc.cid in (

SQL 练习1 一、 建立各种表 1.学生表 Student(SId,Sname,Sage,Ssex) –SId 学生编号,Sname 学生姓名,Sage 出生年月,Ssex 学生性别 create table student(Sid integer,Sname varchar(20),Sage integer,Ssex varchar(20)) charset=utf8; insert into student(Sid, Sname,Sage,Ssex) values(1,‘张三’,18,‘男’); in