SQL & SQL Queries Flashcards
1
Q
When would you use a CASE statement?
A
When you want your query to return records that meet certain conditions using an if/then statement.
2
Q
Why would you use a CAST function?
A
Converts one datatype to another.
3
Q
Why would you use a COALESCE function?
A
To return non-null values in a list.
4
Q
What function would you use to add strings together to create a unique identifier?
A
CONCAT
