SELECT Statement

Select

With this statement, it is possible to query information from one or more tables of a database

result

The result of a SELECT statement is another table, also known as a _____ set

SELECT ALL / DISTINCT col_list
FROM table1 [tab_alias1] ;

Syntax for selecting table

table1

SELECT ALL / DISTINCT col_list
FROM table1 [tab_alias1] ;

is the name of the table from which information is retrieved.

tab_alias1

SELECT ALL / DISTINCT col_list
FROM table1 [tab_alias1] ;

provides an alias for the name of the corresponding table

asterisk symbol (*)

the _______ specifies all columns of the named tables' in the FROM clause

column_name [AS] column_heading

the specification _______, which is a way to replace the name of a column or to assign a new name to an expression

ALL

specifies that all matching rows should be returned, including duplicates

DISTINCT

specifies removal of duplicate rows from the result set

WHERE

The ____ clause specifies a Boolean expression that is tested for each row to be returned.

true, false

If the expression is ____, then the row is returned; if it is ____, it is discarded

<> or !=

Not equal operator

!>

Not greater than operator

!<

Not less than operator

NOT, AND, OR

Multiple conditions can be built using the Boolean operators ___, ____, and ___

IN

The ___ operator is equivalent to a series of conditions, connected with one or more OR operators

BETWEEN

Searches for all values in the range inclusively; that is qualifying values can be between or equal to the lower and upper boundary values

NOT

The BETWEEN operator can also be used to search for column values that do not fall within the specified range by using the Boolean operator ____.

FALSE

All comparisons with NULL values will return ____

IS NULL

To retrieve the rows with NULL values in the column, we use the _____ operator

LIKE

____ is an operator that is used for pattern matching; that is, it compares column values with a specified pattern

pattern

a string that is compared against values of a corresponding column

Wildcard characters

certain characters within the pattern that have a specific interpretation

% (percent)

specifies any sequence of 0 or more characters

_ (underscore)

specifies any single character

[] (square brackets)

delimit a range or list of characters

^

specifies the negation of a range or a list of characters. Can only be used within a pair of square brackets