- 5.3.4.1 选择所有数据5.3.4.1 Selecting All Data
- 5.3.4.2 选择特定行5.3.4.2 Selecting Particular Rows
- 5.3.4.3 选择特定列5.3.4.3 Selecting Particular Columns
- 5.3.4.4 排序行5.3.4.4 Sorting Rows
- 5.3.4.5 日期计算5.3.4.5 Date Calculations
- 5.3.4.6 处理 NULL 值5.3.4.6 Working with NULL Values
- 5.3.4.7 模式匹配5.3.4.7 Pattern Matching
- 5.3.4.8 计算行数5.3.4.8 Counting Rows
- 5.3.4.9 使用多个表5.3.4.9 Using More Than one Table
SELECT 语句用于从表中提取信息。语句的一般形式为:The SELECT statement is used to
pull information from a table. The general form of the statement
is:
SELECTwhat_to_selectFROMwhich_tableWHEREconditions_to_satisfy;
what_to_select 表示您想查看的内容。这可以是一列列名的列表,或者使用 * 表示 “所有列。” which_table 表示您想从中检索数据的表。WHERE 子句是可选的。如果存在,conditions_to_satisfy 指定一条或多条行必须满足的条件,以便符合检索资格。what_to_select indicates what you
want to see. This can be a list of columns, or
* to indicate “all columns.”
which_table indicates the table from
which you want to retrieve data. The WHERE
clause is optional. If it is present,
conditions_to_satisfy specifies one
or more conditions that rows must satisfy to qualify for
retrieval.