Site Menu
- Home
- Products
- NexusDB
- Nexus Quality Suite
- NexusDB Drivers & Connectors
- Nexus Remoting
- Nexus Memory Manager
- Some of our Customers
- Testimonials and use(r)s
- Downloads
- Documentation
- Support
- Pricing & Orders
- About
- Community
- My Nexus
- Recently Updated ...
- Search...
- Site Login
Search
Null Predicate
Wed, 03/04/2009 - 20:02 | hdanzl
Specify a test for a null value.
Syntax
Notes
♦ | The degree of the row value predicand shall be 1. |
♦ | IS NULL evaluates to TRUE if the row value is null, else to FALSE. |
♦ | IS NOT NULL evaluates to TRUE if the row value is different from null, else to FALSE. |
Examples
1) | The following example selects students who don't take any courses: |
SELECT studentID, studentName
FROM students s
left join enrolls e ON e.studentID = s.studentID
WHERE e.studentID IS NULL
Conformance
SQL:2003 standard |
- - |
Core SQL Feature F481 "Expanded NULL predicate" |
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.
1x | NexusDB AWE DLL (10 installations; binary) | AUD 1,950.00 |
1x | SLA - Gold (add years in quantity field) | AUD 3,600.00 |
2x | NexusDB Developer DCU Edition | AUD 1,170.00 |
1x | NexusDB AWE DLL (40 installations; binary) | AUD 6,400.00 |
1x | NexusDB PHP Connector | AUD 500.00 |
1x | NexusDB AWE DLL (100 installations; binary) | AUD 12,500.00 |
1x | NexusDB Developer Source Edition | AUD 890.00 |
1x | NexusDB AWE DLL (1 installation; binary) | AUD 330.00 |
1x | NexusDB Professional Edition | AUD 1,400.00 |
10 Items | Total: AUD 28,740.00 |
(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