Match the following terms to their definition
I. INNER JOIN
II. OUTER JOIN
III. FULL JOIN
IV. Union query
V. SQL subquery
A. Returns only the rows that actually match
B. Returns all rows from both tables
C. Usually added in the WHERE clause
D. Returns all rows from at least one of the tables
E. Combines two SQL SELECT statements
A, D, B, E, C
You might also like to view...
In Excel, functions are ________ formulas
Fill in the blank(s) with correct word
The default slide layouts are set up in portrait orientation.
Answer the following statement true (T) or false (F)
The year you were born determines the generation you fit into
Indicate whether the statement is true or false
Which function returns the rank of a value within a dataset, assigning an average rank for tied values?
A) RANK.EQ B) AVERAGERANK C) RANK.AVG D) RANK.TIE