Subquery Concepts Chapter 8 Subqueries

← Back to document page

1Chapter 8Subqueries Subquery Concepts A SELECT statement nested within the FROM, WHERE, or HAVING clause of another SQL statement The Subquery (inner query) executes once, beforethe main query The resultof the Subquery is passed to the main query (outer query)2SELECTselect_listFROMtableWHEREex pr operator(SELECTselect_listFROMtable);Sub query Concepts Subqueries are an alternative to running a seriesof queries where the result of one query is the input for another subqueriesare useful when a query is based on unknown values Incremental Development what work should the subquerydo? Which writers have same freelancer status as K Cox?3SELECT ln, fn, freelancerFROM writerWHERE freelancer ='Y';SELECT freelancerFROM writerWHERE writerid ='C200';Simple Subquery Which writers are the same freelancer status as Kelly Cox?

1 Chapter 8 Subqueries Subquery Concepts A SELECT statement nested within the FROM, WHERE, or HAVING clause of another SQL statement The subquery (inner query) executes once , before the

  Chapter, Concept, Testament, Subqueries, Concepts chapter 8 subqueries, Chapter 8 subqueries