Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Union All vs Union

Combine the cities of customers and suppliers into one list that keeps duplicates, ordered alphabetically, with the column name city.

Table schema

Customers(id INT, city VARCHAR(50))
Suppliers(id INT, city VARCHAR(50))

Sample data

Customers cities: Pune, Delhi
Suppliers cities: Pune, Mumbai

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.