CodesJava

Easy learning with example program codes

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.

 

Sign Up/ Sign In
Ask a Question


Industrial Training

We offers Placement Oriented Training on Java, Spring, JSF, Hibernate, PHP, AngularJS, Angular 4, PLSQL, Oracle BI Publisher etc. We also provides Online training, please mail us at hr@codesjava.com.

Development

We also provides the Development services for Website Development , Java Development, PHP Development, Android App Development etc. You can contact us on hr@codesjava.com.

Copyright © 2018 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki