Card Set Information
SQL Structured Query Language Database
SQL query clauses, functions, and operators
Specifies the columns to retrieve in the query.
Specifies any conditions for the query
Specifies that all simple conditions must be true for the compound condition to be true
Specifies that the compound condition is true whenever any of the simple conditions is true.
Reverses the truth or falsity of the orginal condition
Finds rows that do not contain a null value in the specified column
IS NOT NULL operator
Finds rows that contain a null value in the specified column
IS NULL operator
Calculates the average value in a numeric range
Specifies a range of values in a condition
Counts the number of rows in a table
Sorts the query results in descending order based on the column name
Indicates the table from which to reetrieve the specified columns
Groups rows based on the specified column
GROUB BY clause
Limits a condition to the groups that are included
Uses the IN operator to find a value in a group of values specified in the condition
Indicates a pattern of characters to find in a condition
Calculates the maximum value in a numeric range
Calculates the minimum value in a numberic range
Lists the query results in the specified order based on the column name
ORDER BY clause
Totals the values in a numeric range
How do you form a compound condition?
combine simple conditions and using the operators AND, OR, or NOT
How do you use a computed column in SQL? How do you name the computed column?
use arithmetic operators and write the computation in place of a column name. assign a name to the computation by following the computation with the word AS and then the desired name.
What wildcards are available in Oracle, and what do they represent?
In Oracle, the percent (%) wildcard represents any collection of characters. The underscore (_) wildcard represens any single character.
How do you sort data?
ORDER BY clause
How do you sort data in descending order?
follow the sort key with the DESC operator
How do you avoid including duplicate values in a query's results?
precede the column name with the DISTINCE operator
How do you group data in an SQL query?
How do you find rows in which a particular column contains a null value?
IS NULL operator in the WHERE clause
what is it called when one query is inside another query?