Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <blockquote> <p><strong><a href="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/between-transact-sql" rel="nofollow noreferrer">BETWEEN</a> (Transact-SQL)</strong></p> <p>Specifies a(<em>n</em>) (<em>inclusive</em>) range to test.</p> </blockquote> <pre><code>test_expression [ NOT ] BETWEEN begin_expression AND end_expression </code></pre> <blockquote> <p><strong>Arguments</strong></p> <pre><code>test_expression </code></pre> <p>Is the expression to test for in the range defined by begin_expression and end_expression. test_expression must be the same data type as both begin_expression and end_expression.</p> <pre><code>NOT </code></pre> <p>Specifies that the result of the predicate be negated.</p> <pre><code>begin_expression </code></pre> <p>Is any valid expression. begin_expression must be the same data type as both test_expression and end_expression.</p> <pre><code>end_expression </code></pre> <p>Is any valid expression. end_expression must be the same data type as both test_expression and begin_expression.</p> <pre><code>AND </code></pre> <p>Acts as a placeholder that indicates test_expression should be within the range indicated by begin_expression and end_expression.</p> <p><strong>Remarks</strong></p> <p>To specify an exclusive range, use the greater than (>) and less than operators (&lt;). If any input to the BETWEEN or NOT BETWEEN predicate is NULL, the result is UNKNOWN.</p> <p><strong>Result Value</strong></p> <p>BETWEEN returns TRUE if the value of test_expression is greater than or equal to the value of begin_expression and less than or equal to the value of end_expression.</p> <p>NOT BETWEEN returns TRUE if the value of test_expression is less than the value of begin_expression or greater than the value of end_expression.</p> </blockquote>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. This table or related slice is empty.
    2. VO
      singulars
      1. This table or related slice is empty.
    3. VO
      singulars
      1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload