System Aspects of SQL

Queries in PSM

There are many ways that select-from-where queries are used in PSM. 1. Subqueries can be used in conditions, or in general, any place a subquery is legal in SQL. We saw two examples of subqueries in lines (3) and (6) of "Branching Statements" Figure 2, for instance.

Page 2 of 2 Previous 1 2 Next