How To Self Join In Sql Youtube

SQL Self Join Example | Self Join in SQL Tutorial

Last updated Dec 21, 2019 0

SQL Cocky Join is the kind of bring together in which a table is joined with itself means we are joining a tabular array with that same table (which is too chosen Unary relationships), particularly when the table has the Strange KEY which references its Master KEY. If we desire to join the tabular array itself means that each row of the tabular array is combined with itself and with every other row of the table.

The self join allows you lot to join the table to itself. It is useful for querying the hierarchical information or comparing rows inside the same table. Till at present, we have seen the Outer Join, Cross Join, Left Join, SQL Joins Overview and Inner Join in this blog.

#SQL Self JOIN Key Points

1. The self JOIN occurs when a table takes a 'selfie.'
2. The cocky JOIN is a regular bring together, but the tabular array is joined with itself.
3. It tin can be useful when modeling hierarchies.
4. They are likewise useful for comparisons within the tabular array.
5. You lot use the self join when the tabular array references data in itself.
6. One most used example is where you wanted to become a list of employees and their immediate managers.

SQL Self Bring together Example

The self join uses an inner bring together or left bring together clause. Because the query that uses the self bring together references a aforementioned tabular array, the table alias is used to assign the different names to a same table within the query. The cocky-join tin can be viewed as a join of two copies of the same tabular array.

The tabular array is not copied, but SQL performs a command every bit though it were. The syntax of a command for joining a table to itself is almost the same equally that for the joining two different tables.

If we want to distinguish the column names from one another, aliases for an actual table proper noun are used, since both the tables have the same name. Tabular array proper noun aliases are defined in a FROM clause of the SELECT statement.

#Self JOIN Syntax

SELECT column_name(s) FROM table1 T1, table1 T2 WHERE condition;

In the above syntax, T1 andT2 are dissimilar table aliases for the aforementioned table.

Encounter the following table.

Products

#SQL Self JOIN Case

The post-obit SQL argument matches Products that have dissimilar categories.

SELECT A.ProductID, A.ProductName AS ProductNameA, B.ProductName AS ProductNameB, A.Category FROM Products A, Products B WHERE A.`ProductName` <> B.`ProductName` AND A.`Category` = B.`Category` Order By B.`ProductName`;

Come across the following output.

In the to a higher place query, we have used a WHERE condition and ORDER By clause.

Finally, SQL Cocky Join example tutorial is over.

Source: https://appdividend.com/2019/06/17/sql-self-join-tutorial-with-example-self-join-in-sql/

Posted by: spiveystootherents.blogspot.com

Share this post