How to display fields with the same values?

Question

SQL Server

There is a workers table with fields name, salary. How to display names with the same salary values?

Answer 1

For example like this:

select STRING_AGG(Name, ',') as Names, Salary from Workers group by Salary;

Run SQL online