SQL Where Clause flash cards

Set: SQL Where Clause

Familiarize		Learn		Test
Play Scatter			Play Space Race

Term	Definition
SELECT column_name(s)FROM table_name WHERE column_name operator value	used 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
BETWEEN	Between an inclusive range
LIKE	Search for a pattern
IN	If you know the exact value you want to return for at least one of the columns
quotation marks	representation of words and sentences
no quotation marks	represented of numeric values

No Messages

Report as inappropriate