Inserts, Updates, and DeletesInsert StatementsUpdate StatementsDelete StatementsQueriesBasic Query ConstructionThe select() function versus the select() methodResult set objectsOperators and functions in WHERE clausesUsing custom bind parametersUsing literal text in queriesOrdering and grouping results, returning distinct valuesLimiting results returnedUsing the “generative” query interfaceJoins and Set OperationsJoining selectablesSet operations (UNION, INTERSECT, EXCEPT)Using aliasesSubqueriesEmbedding subqueries in the column listCorrelated versus uncorrelated subqueriesEmbedding subqueries in an IN clauseEmbedding subqueries in the FROM clause