Matches in DBpedia 2016-04 for { <http://dbpedia.org/resource/Correlated_subquery> ?p ?o }
Showing triples 1 to 29 of
29
with 100 triples per page.
- Correlated_subquery abstract "In a SQL database query, a correlated subquery (also known as a synchronized subquery) is a subquery (a query nested inside another query) that uses values from the outer query. Because the subquery is evaluated once for each row processed by the outer query, it can be inefficient.Here is an example for a typical correlated subquery. In this example we are finding the list of all employees whose salary is above average for their departments.In the above query the outer query isand the inner query (the correlated subquery) isIn the above nested query the inner query has to be re-executed for each employee. (A sufficiently smart implementation may cache the inner query's result on a department-by-department basis, but even in the best case the inner query must be executed once per department. See \"Optimizing correlated subqueries\" below.)Correlated subqueries may appear elsewhere besides the WHERE clause; for example, this query uses a correlated subquery in the SELECT clause to print the entire list of employees alongside the average salary for each employee's department. Again, because the subquery is correlated with a column of the outer query, it must be re-executed for each row of the result.".
- Correlated_subquery wikiPageExternalLink understanding-correlated-subquery.
- Correlated_subquery wikiPageID "20389371".
- Correlated_subquery wikiPageLength "3599".
- Correlated_subquery wikiPageOutDegree "9".
- Correlated_subquery wikiPageRevisionID "703017141".
- Correlated_subquery wikiPageWikiLink Category:SQL.
- Correlated_subquery wikiPageWikiLink Correlated_subquery.
- Correlated_subquery wikiPageWikiLink Database.
- Correlated_subquery wikiPageWikiLink Join_(SQL).
- Correlated_subquery wikiPageWikiLink Query_language.
- Correlated_subquery wikiPageWikiLink SQL.
- Correlated_subquery wikiPageWikiLink Select_(SQL).
- Correlated_subquery wikiPageWikiLink Sufficiently_smart_compiler.
- Correlated_subquery wikiPageWikiLink Where_(SQL).
- Correlated_subquery wikiPageWikiLinkText ""Optimizing correlated subqueries"".
- Correlated_subquery wikiPageWikiLinkText "correlated subquery".
- Correlated_subquery wikiPageWikiLinkText "subqueries".
- Correlated_subquery subject Category:SQL.
- Correlated_subquery hypernym Subquery.
- Correlated_subquery type Language.
- Correlated_subquery type Language.
- Correlated_subquery comment "In a SQL database query, a correlated subquery (also known as a synchronized subquery) is a subquery (a query nested inside another query) that uses values from the outer query. Because the subquery is evaluated once for each row processed by the outer query, it can be inefficient.Here is an example for a typical correlated subquery.".
- Correlated_subquery label "Correlated subquery".
- Correlated_subquery sameAs Q5172838.
- Correlated_subquery sameAs m.04_0ylp.
- Correlated_subquery sameAs Q5172838.
- Correlated_subquery wasDerivedFrom Correlated_subquery?oldid=703017141.
- Correlated_subquery isPrimaryTopicOf Correlated_subquery.