INSTRUCTOR VINAY NOAH Select Query + Comparison Operators For numbers ( INT , DECIMAL , FLOAT ), you could use comparison operators: '=' (equal to), '<>' or '!=' (not equal to), '>' (greater than), '<' (less than), '>=' (greater than or equal to), '<=' (less than or equal to), to compare two numbers. For example, price > 1.0 , quantity <= 500 . CAUTION: Do not compare FLOAT s (real numbers) for equality ( '=' or '<>' ), as they are not precise. On the other hand, DECIMAL are precise. For strings, you could also use '=' , '<>' , '>' , '<' , '>=' , '<=' to compare two strings (e.g., productCode = 'PEC'). The ordering of string depends on the so-called collation chosen. For example, + + String Pattern Matching – LIKE ...
Comments
Post a Comment