|
運算子
|
日期欄位
|
數字欄位
|
文字欄位
|
列舉類型
|
|---|---|---|---|---|
|
介於 (between)
|
X (預設)
|
|||
|
null
|
X
|
X
|
X
|
X
|
|
not null
|
X
|
X
|
X
|
X
|
|
yesterday
|
X
|
|||
|
last week
|
X
|
|||
|
last month
|
X
|
|||
|
last quarter
|
X
|
|||
|
last year
|
X
|
|||
|
today
|
X
|
|||
|
this week
|
X
|
|||
|
this month
|
X
|
|||
|
this quarter
|
X
|
|||
|
this year
|
X
|
|||
|
tomorrow
|
X
|
|||
|
next week
|
X
|
|||
|
next month
|
X
|
|||
|
next quarter
|
X
|
|||
|
next year
|
X
|
|||
|
equals
|
X
|
X (預設)
|
X
|
X (預設)
|
|
not
|
X
|
X
|
X
|
X
|
|
like
|
X (預設)
|
|||
|
not like
|
X
|
|||
|
in
|
X
|
X
|
||
|
not in
|
X
|
X
|
||
|
>
|
X
|
X
|
X
|
|
|
>=
|
X
|
X
|
X
|
|
|
<
|
X
|
X
|
X
|
|
|
<=
|
X
|
X
|
X
|