Flashcard.txt

Card Set Information

Author:
Anonymous
ID:
190696
Filename:
Flashcard.txt
Updated:
2012-12-27 15:40:12
Tags:
Select statment
Folders:

Description:
Select Statement
Show Answers:

Home > Flashcards > Print Preview

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


  1. Not Equal
    <> or !=
  2. Firstname of Lisa or david
    • where firstname = 'lisa' or firstname = 'david'
    • where firstname IN ('lisa','david')
  3. Find all that start with letter d
    • where FirstName like 'd%' ( Anything starting with d)
    • where Firstname like '%d' ( Antything ending with d)
    • where FirstName like '_a%' (Antything with A in second)
  4. Find all that start with a or b
    • where FirstName like 'a%'
    • or FirstName like 'b%'
  5. Find all that start a though k
    where FirstName like '[a-k]%' (Sting is in ' ' can use _)
  6. Find amounts between certain numbers
    where Amount between 21000 and 30000
  7. Find special characters in a name such as % or _
    where GrantName like '%[%]%' (in the [] you put in the character)

What would you like to do?

Home > Flashcards > Print Preview