Skip to main content

Regatta home page

Support
Start Coding
Start Coding

Docs Home
Quickstart
SQL
Regatta Cloud
Self-Hosted Deployment
Drivers & Clients
Tuning Performance

SQL Specification

Introduction

Data Types

Introduction
Character types
Date/Time types
Boolean types
ROW IDs

SQL Syntax Conventions

SQL Syntax Conventions

Data Definition Language (DDL) Commands

CREATE TABLE
ALTER TABLE
DROP TABLE

Data Manipulation Language Commands

INSERT
UPDATE
DELETE

Transaction Control Language Commands

Transaction Control Language Commands
SET TRANSACTION

Data Query Language

SELECT
EXPLAIN

Hints

Overview
General notes

SQL Functions and Operators

SQL Functions and Operators
Comparison Functions and Operators
String Functions and Operators
Date/Time Functions and Operators
- Subquery Expressions
- IN and NOT IN

Managing Users

CREATE USER
ALTER USER
DROP USER

System Monitoring

Using System Monitoring Views
SHOW SYSTEM VIEWS

Appendices

Identifiers Limitations
Database Limitations
Reserved Words

Subquery Expressions

Subquery Expressions

Documentation Index
Fetch the complete documentation index at: https://docs.regatta.dev/llms.txt
Use this file to discover all available pages before exploring further.

This section describes the available subquery expressions. Note that subqueries can be used only in the FROM or the WHERE clauses.

Was this page helpful?

Examples IN and NOT IN

⌘I

Assistant

Responses are generated using AI and may contain mistakes.