SQL+CE 源代码

use student_class select * from Student

use student_class select student.* from student,sc where student.sclass=sc.sclass and student.sno=sc.sno and sc.sclass='1'and …

use student_class select * from course where ccredit between 2.0 and 4.0

use student_class create table SC (sclass varchar(2),--班级 sno varchar(2),--编号 cno varchar(3),--课程号 grade real check(grade=0.0…

select * from student where exists ( select * from sc where cno in ( select cno from sc where sclass='1'and sno='2' )…

select student.*,sc. grade from student,sc where student.sno in(select sno from sc where sclass=1 group by s…

use student_class select distinct student.* --用distinc去重 from student ,sc where student.sclass=sc.sclass and student.sno=sc.sno…

use student_class select cno ,cname from course where cpno is null--不能用=null

use student_class select sname,ssex,grade from student,sc where student.sclass=sc.sclass and student.sno=sc.sno and cno='1'

select sclass,sno from sc where cno=1 and sno not in(select sno from sc where cno=2)