SQL Flashcards
1
Q
Real
A
decimal value
2
Q
Statement
A
command that ends with ;
3
Q
Clause
A
Perform a special task (aka command) in CAPITAL LETTERS
4
Q
Paramater
A
List of columns, values, data types that are passed to a command
5
Q
PRIMARY KEY
A
Uniquely identify a row - attempts to add another row with the same value will not be accepted
6
Q
UNIQUE
A
Similar to PRIMARY KEY but a table can have several UNIQUE columns
7
Q
DEFAULT
A
Assumed value if a value is not provided
8
Q
DISTINCT
A
Filters columns to unique values
9
Q
WHERE
A
Sets a condition to filters rows
10
Q
Aggregates
A
calculations performed on multiples rows
