实验指导书p71(1),共6小题
表结构:
CREATE DATABASE JXGL
USE JXGL
CREATE TABLE student
( SNO CHAR(5) PRIMARY KEY,
SNAME VARCHAR(20),
SAGE SMALLINT CHECK(SAGE>=15 AND SAGE<=45),
SSEX CHAR(2) DEFAULT '男' CHECK(SSEX='男' OR SSEX='女'),
SDEPT CHAR(2));
表样例
Student
表:
结果表
代码如下 :
SELECT SNO,SNAME
FROM student
WHERE SAGE>23
AND SSEX='男'