��関�る優先順�

演算��優先順�を高�も��ら低�も��並��示���。
  • (), ?, 定数 (符å?·ã‚’å?«ã‚€), NULL, 列å?‚ç…§, スカラー副å•?å?ˆã?›, CAST
  • LENGTH, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, ã??ã?®ä»–ã?®çµ„è¾¼ã?¿é–¢æ•°
  • å?˜ä¸€ã?®ã‚ªãƒšãƒ©ãƒ³ãƒ‰ã‚’ã?¨ã‚‹+ã?Šã‚ˆã?³-
  • *, /, || (連çµ?)
  • 二ã?¤ã?®ã‚ªãƒšãƒ©ãƒ³ãƒ‰ã‚’ã?¨ã‚‹+ã?Šã‚ˆã?³-
  • 比較ã€? 定é‡?比較ã€? EXISTS, IN, IS NULL, LIKE, BETWEEN, IS
  • NOT
  • AND
  • OR

演算å­?を括弧ã?®ä¸­ã?«æ›¸ã??ã?“ã?¨ã?«ã‚ˆã‚Šã€?優先順ä½?を明示的ã?«æŒ‡å®šã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚括弧ã?®å¤–ã?«ã?‚る演算å­?ã?Œæ‹¬å¼§ã?®ä¸­ã?®å¼?ã?«é?©ç”¨ã?•れるå‰?ã?«ã€?括弧ã?®ä¸­ã?®æ¼”ç®—å­?ã?¯è©•価ã?•れã?¾ã?™ã€‚

例

(3+4)*9
(age < 16 OR age > 65) AND employed = TRUE
関連概念
動的パラメータ
関連資料
�択�
TableExpression
VALUESå¼?
真��