• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Day 5. Finding the Data You Need: An Int... > Qualifying a SELECT Statement with C...

Qualifying a SELECT Statement with Conditions

By adding one or more conditions to my WHERE clause, I can get very specific as to which records I want my query to retrieve. Each condition functions like a true-false statement: If the query examines a record in which the conditional statement is true, the record is returned as output. If the statement is false, the query ignores the record and moves on.

SQL uses two types of operators to build conditional statements, relational operators and logical operators.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint