Category Archives: sql

UNION vs JOIN Table of content SQL provides various relational operators to handle data that is spread across multiple tables in a relational database. Out of them, UNION and JOIN queries are fundamentally used to combine data from multiple tables. Even though they are both used for the same purpose, i.e. to combine tables, there […]

SQL – Unique Key Table of content The SQL Unique Key The SQL Unique Key (or, Unique constraint) does not allow duplicate values in a column of a table. It prevents two records from having same values in a column. Unique Key is just an alternative to the Primary Key; as both Unique and Primary […]

SQL – UNION vs UNION ALL Table of content UNION and UNION ALL operators are just the SQL implementation of algebraic set operators. Both of them are used to retrieve the rows from multiple tables and return them as one single table. The difference between these two operators is that UNION only returns distinct rows […]