更有效的方法是通过在where子句中放置条件来过滤数据库行,在from子句中指定表之后会立即对where子句求值。
A more efficient technique is to filter database rows by placing conditions in the WHERE clause, which is evaluated immediately after the tables are specified within the FROM clause.
条件中指定的变量必须在设置了断点的行中,否则表达式就没有什么意义!
The variables specified in the condition must be in scope at whatever line you set the breakpoint on, otherwise the expression wouldn't make sense!
or节点告诉我们,它将匹配满足它的子节点所指定的一个或多个条件的任何行。
The or node tells us that we'll match any rows that satisfy one or more of the criteria specified by its child nodes.
再加上指定测试条件的行,该语句就完整了,指定测试条件的行用来组成from子句以组成谓语。
This statement is then completed by the row specifying the test condition, which is also used to populate the FROM clause and additional the WHERE clause so forming a predicate.
由于我们没有指定任何连接条件,所以第一个结果集中的每一行将会连接第二个中的每一行,从而产生57*21行。 。
Since eI have not specified any join condition, each row from the first result set will join with eachrow from the second one, producing 57*21 rows.
如上所述,信用证项下的偿付责任不以开证行收到单据为条件,而是以相符交单提交到指定银行为条件。
The reimbursement obligation under a credit, as outlined above, is not subject to the receiving of documents by the issuing bank, but only to a compliant presentation being made to the nominated bank.
SELECT语句中的WHERE子句指定具体检索哪些行的搜索条件。
The WHERE clause in a SELECT statement specifies the search conditions for exactly which rows are retrieved.
通过输入搜索条件指定要复制的行。
添加搜索条件(如果有的话),以指定要汇总的行子集。
Add search conditions, if any, to specify the subset of rows you want to summarize.
单击“数据”菜单中的“筛选”,并选择“自动筛选”命令,可以显示所有符合指定条件的数据行。
To show only rows that match specific criteria, point to Filter on the Data menu, and then click AutoFilter.
“添加where子句”对话框可以通过指定限制返回的行的搜索条件,进一步定义SQL数据源的SELECT语句。
Add WHERE Clause dialog box enables you to further define a SELECT statement of a SQL data source by specifying search conditions that restrict the rows returned.
使用指定的大小调整模式调整指定行的高度,还可以选择在列宽随后进行调整的假定条件下计算高度。
Adjusts the heights of all rows using the specified size mode, optionally calculating the heights with the expectation that column widths will subsequently be adjusted.
检查条件约束可指定在资料表中为一或多个资料行所接受的资料值或格式。
A check constraint specifies the data values or formats that are acceptable in one or more columns in a table.
传回显示顺序中第一个符合所指定包含筛选条件需求的资料行。
Returns the first column in display order that meets the given inclusion-filter requirements.
传回显示顺序中第一个符合所指定包含筛选条件需求和排除筛选条件需求的资料行。
Returns the first column in display order that meets the given inclusion-filter and exclusion-filter requirements.
传回显示顺序中第一个符合所指定包含筛选条件需求和排除筛选条件需求的资料行。
Returns the first column in display order that meets the given inclusion-filter and exclusion-filter requirements.
应用推荐