镳邃桕囹
: : = 牋牋牋 篑腩忤
|篑腩忤 AND 镳邃桕囹
|篑腩忤 OR 镳邃桕囹
|NOT 镳邃桕囹
篑腩忤
牋牋牋 : : = 牋牋牋 篑腩忤 耩噔礤龛
| 篑腩忤 between
|篑腩忤 like
|篑腩忤 in
|篑腩忤 exists
篑腩忤 耩噔礤龛
: : = 牋牋牋 耜嚯痦铄 恹疣驽龛 铒屦囹铕 耩噔礤龛 耜嚯痦铄 恹疣驽龛
|耜嚯痦铄 恹疣驽龛 铒屦囹铕 耩噔礤龛
(恹疣驽龛 皴脲牿梃 潆 耱铍狯)
[耜嚯痦铄椻噫屙桢 IS [NOT] NULL
铒屦囹铕 耩噔礤龛
牋牋牋 : : =+| =| < | < | <= | > | > | > =
恹疣驽龛 皴脲牿梃 潆 耱铍狯
: : =牋 牋牋 麴噻 皴脲牿梃 潆 耱铍狯
麴噻 from
[ 麴噻 where]
[麴噻 沭箫镨痤忄龛 [麴噻 having]]
麴噻 皴脲牿梃 潆 耱铍狯
: : = 牋牋牋 SELECT [DISTINCT] 耜嚯痦铄 恹疣驽龛
篑腩忤 between
: : = 牋牋牋 桁 耱铍狯 [NOT] BETWEEN 耜嚯痦铄 恹疣驽龛
AND牋 牋 耜嚯痦铄 恹疣驽龛 篑腩忤 like
: : = 牋牋牋 桁 耱铍狯
[NOT] LIKE 耜嚯痦铄 恹疣驽龛
篑腩忤 in
: : = 牋牋牋 耜嚯痦铄 恹疣驽龛 [NOT] IN (祉铈羼蜮 耜嚯痤)
祉铈羼蜮 耜嚯痤
: : = 牋牋牋 耧桉铌 觐眈蜞眚
| 恹疣驽龛 皴脲牿梃 潆 耱铍狯
篑腩忤 exists
: :=牋 EXISTS (恹疣驽龛鍡皴脲牿梃)