Between Predicate
Wed, 03/04/2009 - 20:02 | 
hdanzl
Specify a range comparison.
Syntax
|
[ NOT ] BETWEEN <row value predicand> AND <row value predicand> |
Notes
| ♦ | The BETWEEN predicate is equal to: |
value1 >= value2 AND value1 <= value3
| ♦ | The degree of the row value predicands shall be 1. |
| ♦ | The data types shall be comparable. |
| ♦ | The result of evaluating the predicate is shown in the Truth table for the AND boolean operator. |
| ♦ | The NOT operator inverts the meaning of the comparison and is equal to: |
NOT ( <row value predicand> BETWEEN <row value predicand> AND <row value predicand> )
Examples
| 1) | The following example selects teachers who earn between $30,000 and $35,000: |
SELECT teacherName, salary
FROM teachers
WHERE salary BETWEEN 30000 AND 35000
Conformance
|
SQL:2003 standard |
- |
Core SQL |
Tags:
Questions? Problems?
- Interested to buy but something put you off?
- Can't find what you're looking for?
- Have a suggestion?
Let us know. If you're having trouble contacting us, please check here.
![[]](/support/modules/ubercart/uc_cart/images/bullet-arrow-up.gif "Expand cart block."){kind=icon}
| 3x | SLA - Silver (add years in quantity field) | AUD 3,000.00 |
| 1x | NexusDB AWE DLL (1 installation; binary) | AUD 330.00 |
| 1x | The Full Monty Pack | AUD 1,800.00 |
| 1x | NexusDB Professional Edition | AUD 1,400.00 |
| 1x | Memory Manager V4 | AUD 360.00 |
| 3x | SLA - Gold (add years in quantity field) | AUD 8,000.01 |
| 1x | Visual Studio Standard Pack | AUD 500.00 |
| 1x | NexusDB AWE DLL (site license; binary) | AUD 2,300.00 |
| 1x | Nexus Quality Suite v1 | AUD 550.00 |
| 4x | SLA - Platinum (add years in quantity field) | AUD 16,000.00 |
| 1x | NexusDB Embedded Source | AUD 430.00 |
| 1x | NexusDB Server License Plugin | AUD 250.00 |
| 1x | NexusDB Starter Edition DCU | AUD 150.00 |
| 20 Items | Total: AUD 35,070.01 |
| (View cart) (Checkout) | |
Site Updates
- Dec 4 2024 - 1:53pm
- Dec 4 2024 - 1:48pm
- Nov 19 2024 - 1:04pm
- Oct 17 2024 - 10:27am
- Jul 24 2024 - 1:22pm