Select Statments
Use this to select all data in table
Identify what is incorrect in this query:
Select *
From Staff
Missing ";"
Non-aggregate functions
What must be included in the group by clause?
Relation or File
What is a table?
Wild card used in the Where clause
What is %?
avg(), sum(), count()
what is an aggregate function?
refers to the subset of the set of all rows found in a table that you wanted returned
Projection
specifies the order of the output
Order By statement
Tuple, record, or observation
What is a row?
used to filter for more than one condition
What is "or"?
Pulls only unique attributes
Distinct
Queries are a function of the
DML
Order by automatically sorts this way
Ascending
Attribute or field?
What is a column?
represents zero, one, or multiple characters
percent sign
Used to give database table or column name a temporary name
aliases
Warner's made up (but real world) term for getting rid of duplicates in projection
De-duping
If you don't want ascending order what do you type in the order by statement
Desc
table name and its attributes
What is a schema?
values represent missing or unknown data
null
followed by a list of attributes
select statement
container to store organized data
relational database
Used to determine which rows are in the groupings in a group by clause
Having clause
Every field in a table must have one ….
what is atomic data type?
What is the not equal operator?
<> or !=