Monday, September 14, 2009

Operators allowed in where condition

Operators Allowed in the WHERE Clause

Operator

Description

=

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

No comments:

Post a Comment

Ads

Your Ad Here