数据库学习笔记（四）

insert语句

INSERT INTO PROJECT

(Department, ProjectName, MaxHours, StartDate)

VALUE

('Finance','2010 Q4 Protfolio',400,'05-OCT-10'')

查询语句

SELECT ColumnName

FROM     TableName

WHERE  SomeConditionExists;

WHERE语句

1、WHERE  Department=‘Account’

AND     Phone = ‘13819875546’

两个条件都要具备

2、WHERE  Department=‘Account’

OR       Phone = ‘13819875546’

具备其中任一条件

3、WHERE  Department IN ('Accounting','Finance','Marketing');

具备三个其中一个即可

4、WHERE  Department NOT IN ('Accounting','Finance','Marketing');

除了这三个条件之外的

3、WHERE  Department IN ('Accounting','Finance','Marketing');

具备三个其中一个即可

5、WHERE EmployeeNumber >=2

AND EmployeeNumber <=5

与

WHERE EmployeeNumber BETWEEN 2 AND 5

相同都表示EmployeeNumber 值在2和5之间包含2和5

6、WHERE ProjectName LIKE ‘2010 Q_ Protfolio Analysis’；

对每个未知的字符使用一个下划线。

7、WHERE Phone LINK ‘360-287-%’

%表示一个或者多个未知字符

8、WHERE Phone IS NULL

显示phone为NULL的行

9、WHERE Phone IS NOT NULL

显示phone不为NULL的行

对查询结构排序

1、ORDER BY Department

以Department升序排列

2、ORDER BY Department DESC

以Department降序排列

3、ORDER BY Department DESC，LastName ASC

先以 Department降序排列，在排列之后的顺序中，相同Department 的，以LastName升序排列