Nandana Pradosh

SQL (Structured Query Language) is a powerful tool used for creating, manipulating and retrieving data from databases. While working with these databases, there are many instances where we have to combine data from one or more tables. This can be easily done using the JOIN operation. The SELF JOIN is a type of JOIN that …

SQL Self Join: Everything You Need to Know Read More »

While working with databases in SQL (Structured Query Language), we may have multiple tables in a single database. In instances where we have to retrieve data from multiple tables and combine them, the JOIN operation comes into play. In this article, we’ll explore the OUTER JOIN operation, a specific type of JOIN operation that combines …

SQL Outer Join: LEFT, RIGHT & FULL With Examples Read More »