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...