Hi All,
I have a table which has ItemNumber,Name,Department and Salaries.
| ItemNumber |
Name |
Department |
Salaries |
| 0 |
A |
English Department |
300 |
| 1 |
A |
English Department |
100 |
| 2 |
A |
English Department |
100 |
| 3 |
A |
English Department |
100 |
| 0 |
A |
Tamil Department |
300 |
| 1 |
A |
Tamil Department |
100 |
| 2 |
A |
Tamil Department |
100 |
| 3 |
A |
Tamil Department |
100 |
I need to group like ItemNumber 0 should be parent and others are sub group of parent