How can i build the sql query for checking the duplicate value in the same column and join in a single query?
Example:
ColumnA = Company Name
ColumnB = Employee number
ColumnA has 3 ACME COMPANY record, each one has 67, 89 and 102 employees, the result must be:
ACME COMPANY, 258 employees.
