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.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.