您要查找的是不是:
- In FOR XML, derived table mappings in AUTO mode are treated opaquely. 在FOR XML中,使用AUTO模式的派生表映射被视为是不透明的。
- Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query. 与派生表的不同之处在于,CTE可自引用,还可在同一查询中引用多次。
- A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. CTE与派生表类似,具体表现在不存储为对象,并且只在查询期间有效。
- One more thing to watch for is the fact derived table is going to be materialized even to execute EXPLAIN statement. 需要考虑的另一方面是,派生表需要被显式处理,尽管只是执行EXPLAIN语句。
- Derived tables allow you to nest queries within a FROM clause. 派生表使您能够在FROM子句中嵌套查询。
- In the following example, the inner SELECT statement (enclosed in parentheses) creates a derived table, grouped by customer id values. 在以下示例中,内部SELECT语句(用括号括起来)创建一个派生表,该派生表是按客户ID值进行分组的。
- When you include a view or derived table in a key join, the view cannot contain UNION, ORDER BY, DISTINCT, GROUP BY, or an aggregate function. 当您在键连接中包括视图或派生表时,该视图不能包含UNION、ORDER BY、DISTINCT、GROUP BY或集合函数。
- The statement must not reference derived tables, temporary tables, or table variables. 语句不能引用派生表、临时表或表变量。
- Adaptive Server Anywhere joins the tables based on the foreign key that has the same role name as the correlation name of the view or derived table. Adaptive Server Anywhere基于其角色名与视图或派生表的相关名具有相同名称的外键连接表。
- With derived tables, you can perform grouping of groups, or you can construct a join with a group, without having to create a view. 使用派生表,您可以对组进行分组或构造与组之间的连接而无需创建视图。
- Derived Tables are still handled by materializing them in the temporary table, furthermore temporary table with no indexes (so you really do not want to join two derived tables for example). 派生表仍然以临时表的方式显式地处理,而且还是没有索引的临时表(因此最好不要像在例子中那样连接2个派生表)。
- Mary has derived a lot of benefit from her tuition. 玛丽从她的教学中得到很大收益。
- Although most queries operate on tables, queries may also retrieve data from other objects that have columns and rows, including views, other queries (derived tables) and stored procedure result sets. 虽然大多数查询都是对表执行操作,但是查询也可以从具有列和行的其它对象(包括视图、其它查询(派生表)和存储过程结果集)中检索数据。
- He has planned to lacquer the old table. 他计划给旧桌子上一层漆。
- Derived Tables in MySQL 5.0 seems to have different implementation from views, even though I would expect code base to be merged as it is quite the same task in terms of query optimization. 0中的派生表似乎和视图实现的方式不同,尽管我从合并的代码基数来看觉得在查询优化上应该是一样的。
- The lamp fell plonk on the table. 台灯砰的一声倒在桌上了。
- Give the table a good rub with this polish. 用这上光剂把桌子好好擦一擦。
- The petition was ordered to lie on the table. 该请愿书奉命暂搁一边,以后讨论。
- Please give the table a good rub with this cloth. 请用这块布好好擦擦桌子。
- We can get six people round this table at a pinch. 必要时这张桌子可以坐六个人。