| Subject | What is the right behaviour of BETWEEN keyword? |
|---|---|
| Author | jebem_ti_registraciju |
| Post date | 2005-09-25T04:09:16Z |
Why there is a difference between (BETWEEN 3 and 8)
and (BETWEEN 8 and 3)?
Does SQL standard EXPLICITLY SAYS
BETWEEN X AND Y means
VALUE >= X and VALUE <= Y
or
VALUE >= MIN(X, Y) and VALUE <= MAX(X, Y)
or it just says (BETWEEN X AND Y)
means between x and y?
and (BETWEEN 8 and 3)?
Does SQL standard EXPLICITLY SAYS
BETWEEN X AND Y means
VALUE >= X and VALUE <= Y
or
VALUE >= MIN(X, Y) and VALUE <= MAX(X, Y)
or it just says (BETWEEN X AND Y)
means between x and y?