CC SQL 6. filtering data

Card Set Information

Author:
dau108
ID:
146221
Filename:
CC SQL 6. filtering data
Updated:
2012-04-07 12:22:29
Tags:
CC SQL filtering data
Folders:

Description:
CC SQL 6. filtering data
Show Answers:

Home > Flashcards > Print Preview

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


  1. using the WHERE clause
    • SELECT prod_name, prod_price
    • FROM products
    • WHERE prod_price = 2.50;
  2. the WHERE clause operators
    • Table 6.1. WHERE Clause
    • = Equality
    • <> Nonequality
    • != Nonequality
    • < Less than
    • <= Less than or equal to
    • > Greater than
    • >= Greater than or equal to
    • BETWEEN Between two specified values

    • SELECT prod_name, prod_price
    • FROM products
    • WHERE prod_price <= 10;
  3. checking for no value
    • SELECT prod_name
    • FROM products
    • WHERE prod_price IS NULL;

What would you like to do?

Home > Flashcards > Print Preview