How to write a query

Deepak Ratan

11y1.1kSQL

This is my table, for this table how to write a ParentChild hierarchy in SQL

Table : Create table Emp(

ID int, --------------------> Child

NatIDNumber int,

LoginID varchar(50),

OrgLevel int, -------------> Parent

JTitle varchar(50),

DOB date

Gender nchar(1)

)

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Saroj Kumar Sahu11y ago
Hi,

acn u try this..
SELECT chilld.ID,chilld.NatIDNumber,
chilld.LoginID,chilld.JTitle,
parent.ID,parent.NatIDNumber,
parent.LoginID,parent.JTitle
FROM Emp AS chilld
LEFT JOIN Emp
AS parent ON chilld.OrgLevel = parent.OrgLevel;
0
Deepak Ratan11y ago
Hi Upendra Pratap Shahi
Its showing ERROR
0
Upendra Pratap Shahi11y ago
use below query-

select cd.ID,cd.NatIDNumber,cd.LoginID,cd.JTitle,pt.ID,pt.NatIDNumber,pt.LoginID,pt.JTitle FROM Emp AS ChildUserType
LEFT JOIN Emp AS ParentUserType ON cd.OrgLevel = pt.OrgLevel;

0
Deepak Ratan11y ago
Hi,
Actually i am not getting clear IDEA about Parent child hierarchy
According to my table can you tell me how to write query
0
Pankaj Kumar Choudhary11y ago
hello @Deepak you can refer this site for understanding Parent child hierarchy in sql

http://www.codeproject.com/Articles/818694/SQL-queries-to-manage-hierarchical-or-parent-child
0