Skip to content
SQLPathLab
Home
Browse all
Guides
SQL Translator
Categories
▾
Browse all
Query Basics
Basic Query
10
Aggregation
9
Joins
5
Data Processing
Conditions and NULL
5
String Functions
3
Date and Time
4
Advanced SQL
Subqueries
2
Set Operations
2
Window Functions
4
CTE and Recursion
2
Database and Data
Data Modification
3
Indexes
1
Transactions
3
☆
Save
☆
Save this page
Browser bookmark
My favorites
简
EN
Home
/
Browse all
/
Set Operations
Set Operations
2 items
Search SQL syntax, functions, and use cases
Search
Filters
Category
All categories
Basic Query
Aggregation
Joins
Conditions and NULL
String Functions
Date and Time
Subqueries
Set Operations
Window Functions
CTE and Recursion
Data Modification
Indexes
Transactions
Apply filters
Clear filters
Set Operations
Set Operations · Intermediate
UNION
combining result sets and removing duplicates.
Set Operations · Intermediate
UNION ALL
combining result sets and keeping duplicates.