sql-join/aggregates Flashcards
1
Q
What is a foreign key?
A
links related tables together
2
Q
How do you join two SQL tables?
A
join clause
3
Q
How do you temporarily rename columns or tables in a SQL statement?
A
with an alias
4
Q
What are some examples of aggregate functions?
A
max( ) min( )
avg( ) sum( )
count( ) every( )
5
Q
What is the purpose of a group by clause?
A
perform a task on designated groups of rows
