Over 10 Million Study Resources Now at Your Fingertips

Download as :
Rating : ⭐⭐⭐⭐⭐
Price : $10.99
Pages: 2

Single-row subqueries can used with these comparison operators

386 Chapter 8: Using Subqueries to Solve Problems


exactly one value. This is a single-row When using subqueries in a WHERE clause,

single-column subquery. For the first SQL you must be aware of which operators will

Subqueries can be used to generate values for the select list of a query to generate an inline view to be used in the FROM clause, in the WHERE clause, and in the HAVING clause. When used in the WHERE or HAVING clauses, single-row subqueries can be used with these comparison operators: =, >, >=, <, <=, <>. Multiple-row subqueries can be used with these comparison operators: IN, NOT IN, ANY, ALL.

Describe the Types of Problems That the Subqueries Can Solve

❑ Selecting rows from a table with a condition that depends on the data within the table can be implemented with a subquery.

❑ Single-row subqueries return one row, possibly with several columns.❑ A scalar subquery returns a single value; it is a single-row, single-column subquery.

❑ A correlated subquery is executed once for every row in the outer query.

How It Works
Login account
Login Your Account
Add to cart
Add to Cart
Make payment
Document download
Download File
PageId: ELI41575E4
Uploaded by :
Page 1 Preview
singlerow subqueries can used with these compariso
Sell Your Old Documents & Earn Wallet Balance