Skip to search formSkip to main contentSkip to account menu

Correlated subquery

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… 
Wikipedia (opens in a new tab)

Related topics

Related topics

7 relations
Apache CassandraDatabaseJoin (SQL)Query language

Papers overview

Semantic Scholar uses AI to extract papers important to this topic.
2016
2016
Optimization strategies of correlated subquery for distributed database
2015
2015
Query processing optimization using disk-based row-store and column-store
Recent OLAP systems, which are usually called HOLAP systems, are often developed using both NSM and DSM storages in a single… 
2014
2014
Complex SQL Predicates as Quantifiers
We propose a logical framework to analyze complex predicates (those involving a subquery) in SQL. We propose a new operator in… 
2014
2014
Grouping Queries with SV-Semantics in Preference SQL
Preference database queries become more and more important in Data Warehousing or Decision Support Systems. In these environments… 
2013
2013
SQL SUBQUERIES: Usage in Clinical Programming
A feature of PROC SQL which provides flexibility to SAS users is that of a SUBQUERY. A SUBQUERY is a query inside a query. A… 
2007
2007
Advanced Concepts of Efficient SQL
2007
2007
Sampling-based randomization techniques for approximate query processing
The past couple of decades have seen a significant amount of research directed towards data warehousing and efficient processing… 
2007
2007
AVOID REDUNDANT JOIN CONDITION IN SQL QUERIES
This paper presents a technique to avoid redundant join condition in SQL queries by forcing execution order for outer queries and… 
2005
2005
The SELECT Statement
By clicking accept or continuing to use the site, you agree to the terms outlined in our Privacy Policy (opens in a new tab), Terms of Service (opens in a new tab), and Dataset License (opens in a new tab)