Card Set Information
3dox2 block3 objective 2b 2c
3dox2 block3 objective 2b-2c
the primary way to do a query in sql is with what?
the select statement
the first thing you must do in sql is what?
specify the data you're interested in
the second thing you must do in sql is what?
indicate the action to be performed with the specified data
used to remove duplicates from the results table
used to select the table from which the data will be gathered
a method of selecting all columns in a table
specify the rows to appear in a query
the where clause
columns in the result table are ordered in the order specified in the
what are the aggregate functions?
count, max, min, sum, avg
this clause combines rows from a select statements result table into groups in which specified coluns have the same value
limits the result table produced from the group by clause
the having clause
using a single select commant to get information from multiple tables
the join operation
joining a table to a copy of itself
the simplest type of subquery
a nested select
the most powerful of the set comparison operators
sql command to add new rows to tables
lets you change the values in one or more slected rows of a table
sql is a type of
individual facts, statistics, or items
data that has been processed into a format that is understandable by its intended audience
some form of output, usually printed, containing organized information