Course 4: Module 3 Flashcards
1
Q
Float
A
A number that contains a decimal
2
Q
CONCAT()
A
Adds strings together to create new text strings that can be used as unique keys
3
Q
COALESCE()
A
Can be used to return non-null values in a list
4
Q
CAST
A
A SQL function that converts data from one datatype to another
5
Q
DISTINCT
A
A keyword that is added to a SQL SELECT statement to retrieve only non-duplicate entries
6
Q
Substring
A
A subset of a text string
7
Q
Typecasting
A
Converting data from one type to another