Week 3 Flashcards
1
Q
CAST
A
A SQL function that converts data from one datatype to another
2
Q
COALESCE
A
A SQL function that returns non-null values in a list
3
Q
CONCAT
A
A SQL function that adds strings together to create new text strings that can be used as unique keys
4
Q
DISTINCT
A
A keyword that is added to a SQL SELECT statement to retrieve only non-duplicate entries
5
Q
LEN
A
A function that returns the length of a text string by counting the number of characters it contains
6
Q
SUBSTR
A
A SQL function that extracts a substring from a string variable
7
Q
TRIM
A
A function that removes leading, trailing, and repeated spaces in data
