groups and sub group levels. from the 1 table same column

I'm not sure what the question is!

Dear BrandonGalderisi:

I am using c1webgrid to display data for grouping

I have one admin and n level of subgroups in same table. How I use the following sample to my cenario.

Example :
                Operations(main group)
                                Abc
                                                Xyz
                                                Pqr
                                Efg
                                                123
                                                321

i want this query in sql server 2005

i want to make a dynamic query to add groups or select groups and sub groups.

Regards
shams.

Is this what you want?

select ParT.groupName, subT.GroupName
from YourTable ParT
join yourTable SubT
on ParT.levelId = sub.parentLevelId

Select allOpen in new window

BrandonGalderisi:

i am using this query, from this its coming upto 3 levels, i want to display n levels.

SELECT BB.LavelName, B.LavelName, E.LavelName
FROM groupslevel e
INNER JOIN groupslevel AS B ON E.LevelParentID=B.levelID
INNER JOIN groupslevel BB ON B.levelparentID=BB.LevelID