Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
Chapter 4:Simple SQL Retrieval > Nulls and Retrieval: Three-Valued Logic - Pg. 101
Nulls and Retrieval: Three-Valued Logic 101 sale_id | sale_date | sale_total_amt ---------+--------------------+---------------- 3 | 15-JUN-13 00:00:00 | 58.00 4 | 30-JUN-13 00:00:00 | 110.00 5 | 30-JUN-13 00:00:00 | 110.00 2 | 05-JUN-13 00:00:00 | 125.00 1 | 29-MAY-13 00:00:00 | 510.00 19 | 01-SEP-13 00:00:00 | 95.00 20 | 01-SEP-13 00:00:00 | 75.00 Figure 4-13: Using NOT BETWEEN to retrieve rows outside a date range sale_id | sale_date | sale_total_amt ---------+--------------------+---------------- 1 | 29-MAY-13 00:00:00 | 510.00 2 | 05-JUN-13 00:00:00 | 125.00 3 | 15-JUN-13 00:00:00 | 58.00 5 | 30-JUN-13 00:00:00 | 110.00 4 | 30-JUN-13 00:00:00 | 110.00 19 | 01-SEP-13 00:00:00 | 95.00 20 | 01-SEP-13 00:00:00 | 75.00
