We have a requirement like below.
e.g.
Consider a table with column as Names.
Names
abc
xyz
abc
pqr
pqr
We want two columns in another table as below.
UniqueNames NamesCount
abc 2
xyz 1
pqr 2
Is there any way to achieve this?