2b-c.txt

Card Set Information

Author:
CapptainClutch
ID:
92597
Filename:
2b-c.txt
Updated:
2011-06-30 17:33:40
Tags:
3dox2 block3 objective 2b 2c
Folders:

Description:
3dox2 block3 objective 2b-2c
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user CapptainClutch on FreezingBlue Flashcards. What would you like to do?


  1. the primary way to do a query in sql is with what?
    the select statement
  2. the first thing you must do in sql is what?
    specify the data you're interested in
  3. the second thing you must do in sql is what?
    indicate the action to be performed with the specified data
  4. used to remove duplicates from the results table
    distinct
  5. used to select the table from which the data will be gathered
    from
  6. a method of selecting all columns in a table
    * asterisk
  7. specify the rows to appear in a query
    the where clause
  8. columns in the result table are ordered in the order specified in the
    select clause
  9. combining fields
    concatenating +
  10. what are the aggregate functions?
    count, max, min, sum, avg
  11. this clause combines rows from a select statements result table into groups in which specified coluns have the same value
    group by
  12. limits the result table produced from the group by clause
    the having clause
  13. using a single select commant to get information from multiple tables
    the join operation
  14. joining a table to a copy of itself
    self-join
  15. the simplest type of subquery
    a nested select
  16. the most powerful of the set comparison operators
    like
  17. sql command to add new rows to tables
    insert
  18. lets you change the values in one or more slected rows of a table
    update
  19. sql is a type of
    dml
  20. individual facts, statistics, or items
    data
  21. data that has been processed into a format that is understandable by its intended audience
    information
  22. some form of output, usually printed, containing organized information
    report

What would you like to do?

Home > Flashcards > Print Preview