Final Exam review part ii Flashcards
1
Q
the _________ function returns the number of rows that matches specified criteria
A
COUNT()
2
Q
__________ converts a character value into a date value
A
to_date
3
Q
__________selects value within a given range. The values can be numbers, text, or dates
A
between
4
Q
__________clause can be used to join columns that have different names; ______ clause is used to specify a join condition
A
ON
5
Q
__________is used to assign an alias to the column or a table. It is inserted between the column name and the column alias or between the table name and the table alias.
A
AS
6
Q
the ____________clause is used to filter records. It is used to extract only those records that fulfill a specified condition.
A
WHERE
