Computer Engineering/DB
오라클 sql 조건 비교 (Comparison Conditions )
야기
2008. 7. 18. 16:34
Comparison Conditions
Operator | Meaning |
= | Equal to |
> | Greater than |
>= | Greater than or equal to |
<= | Less than or equal to |
<> | Not equal to |
BETWEEN... AND ... | Between two values (inclusive) |
IN(set) | Match any fo a list of values |
LIKE | Match a character pattern |
IS NULL | Is a null value |
출처 : 오라클 공인 교재 SQL Fundamentals 2-7