SQL – Self Join Table of content Self Join, as its name suggests, is a type of join that combines the records of a table with itself. Suppose an organization, while organizing a Christmas party, is choosing a Secret Santa among its employees based on some colors. It is designed to be done by assigning […]
Category Archives: sql
SQL – UPDATE JOIN Table of content To update the data entered in a single database table using SQL, you can use the UPDATE statement. However, to update the data in multiple database tables, we need to use the UPDATE… JOIN clause. For instance, if a student changes their primary phone number and wishes to […]
SQL – UNION Operator Table of content The SQL UNION Operator The SQL UNION operator is used to combine data from multiple tables by eliminating duplicate rows (if any). To use the UNION operator on multiple tables, all these tables must be union compatible. And they are said to be union compatible if and only […]