subquery

listen to the pronunciation of subquery
İngilizce - Türkçe
Alt sorgu, alt sorgulama
altsorgu
İngilizce - İngilizce
A query embedded within a more extensive query, relating only to the data returned by the parent query
Using a second query to retrieve additional data within the main query For example,to retrieve all sales where price was greater than the average,the WHERE clause could use a subquery to compute the average price
A query embedded inside another (parent) SQL statement, returning rows used by the parent
A query that is nested in a clause of a SQL command
A query in SQL whose results are used in the search condition of another SQL query (9) See also Correlated subqueries
An SQL query specification that is nested in another query specification, for example, as a part of an IN predicate
A SELECT statement within a WHERE clause