Set: SQL Where Clause

Familiarize

Learn

Test

Play Scatter

Play Space Race

Combine with other sets Login to add to Favorites
Print: Term List | Flashcards Editing not allowed
Export Deleting not allowed

Share these flash cards

With group: None
HTML link to set: Tiny link:
Share on Facebook Share on MySpace

All 12 terms

TermDefinition
SELECT column_name(s)FROM table_name WHERE column_name operator valueused to extract only those records that fulfill a specified criterion
=Equal
<>Not equal
>Greater than
<Less than
>=Greater than or equal
<=Less than or equal
BETWEENBetween an inclusive range
LIKESearch for a pattern
INIf you know the exact value you want to return for at least one of the columns
quotation marksrepresentation of words and sentences
no quotation marksrepresented of numeric values

Set Information

Terms 12
Creator jtwilliams00
Created March 30, 2009
Groups None
Subject sql
Access Anyone
Edit Creator Only
Get rid of ads on Quizlet
Pop out

Discuss

No Messages
Last Message: never

You must be logged in to discuss this set.