I have a table with two columns 1- id 2- parent_id I want a SQL query that take parent_id as perameter and retrieve all its children and children of children and so on upto N level. Data in table like: ID parent_id S1 SG G1 FG GP01 FG GP0101 GP01 G11 G1 G12 G1 G111 G11 G112 G11 G113 G11 If I pass FG as parent_id, the query should return G1,GP01,GP0101,G11,G12,G111,G112,G113. Please help me in this regard