COMPARISON OPERATORS

=, !=, <> 	    ---- TEST FOR EQUAL, NOT EQUAL, NOT EQUAL 
>, >=, <, <= 	---- TEST GREATER THAN, GREATER THAN OR EQUAL TO, LESS THAN, LESS THAN OR EQUAL TO 
BETWEEN AND	    ---- CHECK FOR RANGE BETWEEN AND INCLUDING TWO VALUES 
LIKE 		    ---- SEARCH FOR A MATCH IN STRING, USING THE WILDCARD SYMBOLS % (ZERO OR MULTIPLE CHARACTERS) OR _ (ONE CHARACTER) 
IN ( )          ---- TEST FOR A MATCH IN A SPECIFIED LIST OF VALUES IS NULL, 
IS NOT NULL 	---- CHECK WHETHER IS NULL (NO VALUE), IS NOT NULL

Group by parameters:  COUNT, MAX, MIN, SUM.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s