Create TABLE mapping(Code VARCHAR(10), Parent_code VARCHAR(10), POSITION VARCHAR(10));

INSERT INTO Mappings

VALUES ('H1', NULL, 'Root'),

...

thx WayneS.

I m using almost same query. But my main problem is as below

If i do

Select * from table

where parent_code= 'H1' * H1 is root

The output...

I have used CtE but it did not work