Question

If a numeric column is being used for comparison against the search condition, the search condition is enclosed in single quotation marks. _________________________

Answer 1

comparison operator can be used to specify a range of values as a search condition. When two conditions are joined by the AND logical operator, both of the conditions must be evaluated as TRUE to be included in the query results. In a WHERE clause, logical operators are evaluated before comparison operators.