Lesson 8:Retrieving Data From Multiple Tables

Question 1

Subquery

Answer 1

A subquery is a query embedded in another query

Question 2

SELECT Subquery

Answer 2

A SELECT subquery is embedded as another SELECT statement inside of a query

Question 3

Outer Query

Answer 3

The main query that has an inner query embedded inside it.

Question 4

Inner Query

Answer 4

This is a subquery; the query that is embedded inside another query.

Question 5

IN

Answer 5

The IN conditional operator is a shorthand for multiple OR conditions. IN is used to filter records.

Question 6

NOT

Answer 6

The NOT conditional operator is used to display a row if the condition is not true.

Question 7

NOT IN

Answer 7

NOT IN combines the NOT and IN conditional operators. It will filter the result-set and retrieve rows that are NOT equal to the listed IN criteria.

Question 8

OR

Answer 8

Or is a conditional operator where there are two or more conditions but only one must be true for the condition to be true.

Question 9

AND

Answer 9

AND is a conditional operator for two or more conditions but both or all the conditions must be true for the condition to be true.

Question 10

LIKE

Answer 10

The LIKE operator is used in the WHERE clause to find a specified pattern in a column. It is usually used with a wildcard.

Question 11

Wildcard

Answer 11

A wildcard is a character that substitutes for one or more characters in a string. You have been using the * wildcard.

Question 12

% Wildcard

Answer 12

Represents zero or more characters.

Question 13

_ Wildcard

Answer 13

Represents a single character.