Definitions
from Wiktionary, Creative Commons Attribution/Share-Alike License.
- noun databases A query
embedded within a more extensive query, relating only to the data returned by the parent query.
Etymologies
from Wiktionary, Creative Commons Attribution/Share-Alike License
Support
Help support Wordnik (and make this page ad-free) by adopting the word subquery.
Examples
-
A subquery is a SELECT statement that is embedded in a clause of another SQL statement, called the parent statement.
-
A subquery is a SELECT statement embedded in a clause of another SQL statement.
-
A subquery is a SELECT statement that is nested within another T-SQL statement.
-
Otherwise you could use a similiar subquery to get only the one rank, i.e. (Select Top 1 Ranking From Ranking Where fkBookId = BookId Order By RankingDate DESC)
Waldo Jaquith - One-to-one SQL join from among the many? 2006
-
Change the subquery to use ‘order by r. date desc’ to get the newest ranking.
Waldo Jaquith - One-to-one SQL join from among the many? 2006
-
How can i order (sort) my list of Orders by PayedStatus received by subquery?
-
· The results of a query which contains a LIMIT clause inside a subquery could not be exported and this has been fixed.
Softpedia - Windows - All Softpedia Linux 2010
-
Grouping by a subquery in a query with a DISTINCT aggregate function led to incorrect and unordered grouping values.
-
I tried to use SqlProjection & succesfully received only the result of subquery
-
I need to order results of my query by result of complex subquery of related table.
Comments
Log in or sign up to get involved in the conversation. It's quick and easy.