Oxla Developer Hub home page
Search...
⌘K
Ask AI
Oxla.com
Docker Hub
Blog
Search...
Navigation
Set Operations
Overview
Home
Welcome
Oxla Product Roadmap
Changelog
Introduction
What is Oxla and why use it
Development Guide
Quickstart
Configuration & Deployment
Cloud Storage
SQL Reference
Overview
SQL Statements
SQL Mutations
SQL Clauses
Overview
FROM
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT
OFFSET
Set Operations
Overview
EXCEPT
INTERSECT
UNION
WITH
OVER / WINDOW
SQL Data Types
SQL Functions
Schema Definition
Comment Support
Transactions
Clients & Tools
Security
System Catalogs
Monitoring
Troubleshooting & Optimization
Resources
OLTP vs. OLAP
Oxla vs. PostgreSQL
Set Operations
Overview
Set operations are operations used to manipulate and analyze sets. It includes the following operations:
Union
: Combines two or more sets to create a new set containing all unique elements from the input sets.
Intersect
: Yields a new set with elements common to all input sets.
Except
: Generates a set containing elements from the first set that are not present in the second set.
These operations allow for comparisons, combinations, and distinctions among sets in various contexts.
OFFSET
EXCEPT
Assistant
Responses are generated using AI and may contain mistakes.