建表语句:
CREATE TABLE stu(
Sno1 char(15) NOT NULL,
Sname1 char(20) NULL,
Ssex1 char(2) NULL,
Sage1 smallint NULL,
Sdept1 char(20) NULL
)
INSERT stu (Sno1, Sname1, Ssex1, Sage1, Sdept1) VALUES ('2012000', '李一平', '男', '18', 'IS')
INSERT stu (Sno1, Sname1, Ssex1, Sage1, Sdept1) VALUES ('2012111', '张立', '男', '19', 'IS')
INSERT stu (Sno1, Sname1, Ssex1, Sage1, Sdept1) VALUES ('2012222', '刘晨', '女', '19', 'CS')
INSERT stu (Sno1, Sname1, Ssex1, Sage1, Sdept1) VALUES ('2012333', '王敏', '女', '18', 'MA')
INSERT stu (Sno1, Sname1, Ssex1, Sage1, Sdept1) VALUES ('2012444', '李勇', '男', '20', 'CS')
INSERT stu (Sno1, Sname1, Ssex1, Sage1, Sdept1) VALUES ('201255555', '张琴', '女', &