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

Computer Science & Information Technology

You might also like to view...

In Excel, functions are ________ formulas

Fill in the blank(s) with correct word

Computer Science & Information Technology

The default slide layouts are set up in portrait orientation.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

The year you were born determines the generation you fit into

Indicate whether the statement is true or false

Computer Science & Information Technology

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

Computer Science & Information Technology