SQL operators

  1. Specifies the columns to retrieve in the query.
    SELECT clause
  2. Specifies any conditions for the query
    WHERE clause
  3. Specifies that all simple conditions must be true for the compound condition to be true
    AND operator
  4. Specifies that the compound condition is true whenever any of the simple conditions is true.
    OR operator
  5. Reverses the truth or falsity of the orginal condition
    NOT operator
  6. Finds rows that do not contain a null value in the specified column
    IS NOT NULL operator
  7. Finds rows that contain a null value in the specified column
    IS NULL operator
  8. Calculates the average value in a numeric range
    AVG function
  9. Specifies a range of values in a condition
    BETWEEN operator
  10. Counts the number of rows in a table
    COUNT function
  11. Sorts the query results in descending order based on the column name
    DESC operator
  12. Indicates the table from which to reetrieve the specified columns
    FROM clause
  13. Groups rows based on the specified column
    GROUB BY clause
  14. Limits a condition to the groups that are included
    HAVING clause
  15. Uses the IN operator to find a value in a group of values specified in the condition
    IN clause
  16. Indicates a pattern of characters to find in a condition
    LIKE operator
  17. Calculates the maximum value in a numeric range
    MAX function
  18. Calculates the minimum value in a numberic range
    MIN function
  19. Lists the query results in the specified order based on the column name
    ORDER BY clause
  20. Totals the values in a numeric range
    SUM function
  21. How do you form a compound condition?
    combine simple conditions and using the operators AND, OR, or NOT
  22. 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.
  23. 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.
  24. How do you sort data?
    ORDER BY clause
  25. How do you sort data in descending order?
    follow the sort key with the DESC operator
  26. How do you avoid including duplicate values in a query's results?
    precede the column name with the DISTINCE operator
  27. How do you group data in an SQL query?
  28. How do you find rows in which a particular column contains a null value?
    IS NULL operator in the WHERE clause
  29. what is it called when one query is inside another query?
Card Set
SQL operators
SQL query clauses, functions, and operators