Author Archives: user

SQL – Left Join Table of content Joins are used to retrieve records from two or more tables based on a logical relation between them. This relation is defined using a join condition. As we discussed in the previous chapters, there are two types of Joins − Outer Join Left Join is a type of […]

SQL – DELETE JOIN Table of content Simple deletion operation in SQL can be performed on a single record or multiple records of a table. And to delete records from multiple tables, the most straightforward approach would be to delete records from one table at a time. However, SQL makes it easier by allowing the […]

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 […]