The following are the boolean operators in ElevateDB, ordered by their operator precedence:


Examples

---

-- The following SQL uses the AND Boolean
-- operator to select all shipped orders
-- placed within the last 100 days

SELECT *
FROM Orders
WHERE OrderDate >= CURRENT_DATE-100 AND
ShipDate IS NOT NULL

SQL 2003 Standard Deviations

---

The following areas are where ElevateDB deviates from the SQL 2003 standard: