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
Unique Predicate


Specify a test for the absence of duplicate rows.
Syntax
<unique predicate> ::= UNIQUE <table subquery>
Notes
♦ | The predicate evaluates to TRUE if the subquery result is empty or it contains no duplicate rows, else to FALSE. |
Examples
1) | The following example selects students enrolled in none or only 1 course: |
SELECT studentID, studentName
FROM students s
WHERE UNIQUE (
SELECT studentID
FROM enrolls
WHERE studentID = s.studentID
)
Conformance
SQL:2003 standard |
- |
Feature F291 "UNIQUE 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.
Site Updates
- Nov 19 2023 - 10:34pm
- Nov 9 2023 - 8:55pm
- Jun 6 2023 - 3:12pm
- May 10 2023 - 7:39pm
- Jan 20 2023 - 10:26am