SQL Statements

Question 1

What is does the UNION key word do?

Answer 1

UNION - combines the result of two or more select statements. Both select statements must have the same number of columns and they must be similar data types.

Question 2

What does the IN keyword do?

Answer 2

IN - specify multiple values in a where clause. Checks if the value is in the list of values provided. Can also provide a list of values by passing a select column from another table.

Question 3

What does the BETWEEN key word do?

Answer 3

BETWEEN - selects values within a given range, begin and end values included.

Question 4

Name the wildcard character

Answer 4

% - zero or more characters
_ - single character
[] - any single character within the brackets
^ any character not in the brackets
- single character in a given range

Question 5

What would ‘WHERE Value LIKE ‘a%’’ return?

Answer 5

any values that start with a

Question 6

What would ‘WHERE Value LIKE ‘%a’’

Answer 6

any values that end with a

Question 7

What would “WHERE Value LIKE ‘_r%’” return?

Answer 7

any values that have r in second position