SQL+parser 源代码

create table Course (cno varchar(3),--课号 cname varchar(20) not null,--课名 cpno varchar(3),--先行课 ccredit real ,--学分 primary key…

use student_class select distinct student.sclass ,student.sno from student ,sc x,sc y where student.sclass=x.sclass and student…

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