3.3.4 Retrieving Information from a Table从表中检索信息

3.3.4.1 Selecting All Data选择所有数据
3.3.4.2 Selecting Particular Rows选择特定行
3.3.4.3 Selecting Particular Columns选择特定列
3.3.4.4 Sorting Rows排序行
3.3.4.5 Date Calculations日期计算
3.3.4.6 Working with NULL Values使用NULL值
3.3.4.7 Pattern Matching模式匹配
3.3.4.8 Counting Rows计算行数
3.3.4.9 Using More Than one Table使用多个表

The SELECT statement is used to pull information from a table. SELECT语句用于从表中提取信息。The general form of the statement is:声明的一般形式为:

SELECT what_to_select
FROM which_table
WHERE conditions_to_satisfy;

what_to_select indicates what you want to see. what_to_select表示您希望看到的内容。This can be a list of columns, or * to indicate all columns. 这可以是列的列表,也可以*,表示“所有列”。which_table indicates the table from which you want to retrieve data. which_table表示要从中检索数据的表。The WHERE clause is optional. WHERE子句是可选的。If it is present, conditions_to_satisfy specifies one or more conditions that rows must satisfy to qualify for retrieval.如果存在,则conditions_to_satisfy指定行必须满足的一个或多个条件,以符合检索条件。

3.3.4.1 Selecting All Data
3.3.4.2 Selecting Particular Rows
3.3.4.3 Selecting Particular Columns
3.3.4.4 Sorting Rows
3.3.4.5 Date Calculations
3.3.4.6 Working with NULL Values
3.3.4.7 Pattern Matching
3.3.4.8 Counting Rows
3.3.4.9 Using More Than one Table