set1sele.txt

一个c语言开发的小型的dbms系统

SELECT * FROM Student;
SELECT Cno,Cname,Ccredit FROM Course;
SELECT * FROM SC;
SELECT * FROM Student WHERE Sage>25;
SELECT Sname,Ssex,Sage FROM Student WHERE Sage>22 AND Ssex='F';
SELECT Sname,Ssex,Sage FROM Student WHERE (Sage>27) OR (Ssex='F');
SELECT * FROM Student,SC WHERE Student.Sno=SC.Sno;
SELECT * FROM Student,Course,SC WHERE Student.Sno=SC.Sno AND SC.Cno=Course.Cno;
SELECT Student.Sname,Student.Sage,SC.Cno,SC.Grade FROM Student,SC WHERE Student.Sno=SC.Sno AND SC.Grade>80;
SELECT Student.Sname,SC.Cname,SC.Grade FROM Student,SC,Course WHERE (SC.Cno=Course.Cno AND Student.Sno=SC.Sno) AND (SC.Grade>80 OR Student.Sno='98131002');