Contents Menu Expand Light mode Dark mode Auto light/dark, in light mode Auto light/dark, in dark mode Skip to content
FoundationDB Record Layer documentation
FoundationDB Record Layer documentation
  • Overview and Examples
  • Getting Started Guide
  • Building
  • Schema Evolution and Meta-data Maintenance
  • Extending the Record Layer
  • Versioning Guide
  • Coding Best Practices
  • Release Notes
  • Frequently Asked Questions
  • SQL Reference
    • SQL Data Types
    • SQL Commands
      • DQL
        • SELECT
        • WITH
        • WHERE
        • CASE
        • ORDER BY
        • EXPLAIN
        • Operators
          • Logical Operators
            • EXISTS
          • Comparison Operators
          • IS Operator
          • IS DISTINCT FROM
          • BETWEEN
          • LIKE
          • IN
      • DDL
        • CREATE
          • CREATE SCHEMA TEMPLATE
          • CREATE DATABASE
          • CREATE SCHEMA
          • CREATE TABLE
          • CREATE TYPE
            • CREATE TYPE AS STRUCT
            • CREATE TYPE AS ENUM
          • CREATE INDEX
          • CREATE FUNCTION
        • DROP
          • DROP SCHEMA TEMPLATE
          • DROP DATABASE
          • DROP SCHEMA
      • DML
        • INSERT
        • UPDATE
        • DELETE
    • Functions
      • CAST
      • Aggregate Functions
        • BITMAP_CONSTRUCT_AGG
      • Scalar Functions
        • BITMAP_BIT_POSITION
        • BITMAP_BUCKET_NUMBER
        • BITMAP_BUCKET_OFFSET
    • Joins
    • Databases, Schemas, Schema Templates
    • Tables
    • Indexes
    • Direct Access API
    • Understanding How Bitmaps Identify Distinct Values
  • API
    • fdb-java-annotations
    • fdb-extensions
    • fdb-record-layer-core
    • fdb-record-layer-icu
    • fdb-record-layer-lucene
    • fdb-record-layer-spatial
    • fdb-relational-api
    • fdb-relational-core
    • fdb-relational-cli
    • fdb-relational-grpc
    • fdb-relational-jdbc
  • Contributing
  • Code of Conduct
  • License
Back to top
View this page

OperatorsΒΆ

Arithmetic Operators

+, -, *, /, %

Logical Operators

AND, OR, NOT

Comparison Operators

<, >, <=, >=, =, !=

IS Operator

IS, IS NOT

IS DISTINCT FROM Operator

IS DISTINCT FROM, IS NOT DISTINCT FROM

BETWEEN Operator

BETWEEN, NOT BETWEEN

LIKE Operator

LIKE, NOT LIKE

IN Operator

IN, NOT IN

Next
Logical Operators
Previous
EXPLAIN
Copyright © 2025, Apple Inc.
Made with Furo