subquery

Definitions

noun databases A query embedded within a more extensive query, relating only to the data returned by the parent query.

sub- +‎ query

Help support Wordnik (and make this page ad-free) by adopting the word subquery.

A subquery is a SELECT statement that is embedded in a clause of another SQL statement, called the parent statement.

Recently Uploaded Slideshows 2009
A subquery is a SELECT statement embedded in a clause of another SQL statement.

Recently Uploaded Slideshows 2009
A subquery is a SELECT statement that is nested within another T-SQL statement.

Journey to SQL Authority with Pinal Dave 2008
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?

eggheadcafe.com articles 2010
· 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.

Tweakers.net Mixed RSS Feed 2010
I tried to use SqlProjection & succesfully received only the result of subquery

eggheadcafe.com articles 2010
I need to order results of my query by result of complex subquery of related table.

eggheadcafe.com articles 2010