Tutorialspoint examples

Learn java tutorial with examples for beginners online

SQL SELF JOIN


The SELF JOIN is used to join the table to itself that why it is known as SELF JOIN.

Syntax:

SELECT columnList FROM table1 t1, table1 t2 WHERE t1.commonColumn = t2. commonColumn;

Example:

SELECT emp1.EMP_NAME FROM EMPLOYEE emp1, EMPLOYEE emp2 
WHERE emp1.AGE = emp2.AGE;

Output:

EMP_NAME
Parmender
Nidhi
Parmender
Parbhjot
Parmender
Nidhi
Parmender
Parbhjot
Parmender
Nidhi

 
Next Topic: SQL CARTESIAN JOIN with example.
Previous Topic: SQL FULL OUTER JOIN with example.

Related Topics:

How to build java project using ant in eclipse?
JAXB marshalling – convert java object to xml example.
How to create pdf file in java using iText jar?
Generics class example.
OGNL in struts 2.
Hibernate One-to-One Mapping using xml.
Send inline image in email using JavaMail API.
Quartz 2 JobListener example.

 

Download tutorialspointexamples Android App
Copyright © 2018 Tutorialspoint examples DMCA.com Protection Status