hi everyone,
i am having the below input table
| INPUT |
| Name |
| Hari;shanker;singh |
| Hari;shanker |
| Hari |
need to get the output like below please let me know
| OUTPUT | |
| Name | count |
| Shanker | 2 |
| Hari | 3 |
| Singh | 1 |
Thanks in Advance

Hari ShankerPosted Jun 9, 2016, 2:50 AM
Akshay PhadkePosted Jun 9, 2016, 2:43 AM