how can we set multiple criteria?
Home
/
Computer Science
/
how can we set multiple criteria?
how can we set multiple criteria?
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Answer:
Answer: Using an OR condition enables you to specify several alternative values to search for in a column. Using an AND condition enables you to specify that values in a column must meet two (or more) conditions for the row to be included in the result set.
Explanation:
Type FROM, followed by the name of the first of the tables you want in the query. Press ENTER. If you want to specify a criterion for a field from the first table, type WHERE, followed by the field name, a comparison operator (usually, an equals sign (=)), and the criterion