I have one query like a puzzle for me.
I have one table which has many column and one the column has value like
I need to create a query and need to consider performace.
How to get result like from the above data..
How this can be...
first value 10 ,11,12 is the main group and how many "." comes has is the highest depth and i need to find all the value and need to find result like above...