SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tempTable1(Title varchar(20),  [Count] int);
INSERT INTO tempTable1 VALUES
('Sr.',   11),
('Mrs.',  2),
('Sra.',  3),
('Ms.',   415),
('Mr.',   578);
5 rows affected

DECLARE @Columns as VARCHAR(MAX)
SELECT 
    @Columns = COALESCE(@Columns + ', ','') + QUOTENAME(Title)
FROM
   (
    SELECT TOP 100 PERCENT Title FROM tempTable1 ORDER BY Title
   ) AS P
   
SELECT @Columns;   


(No column name)


[Sr.], [Mrs.], [Sra.], [Ms.], [Mr.]


DECLARE @Columns nvarchar(max);

SET @Columns = STUFF((SELECT ', ' + QUOTENAME(Title)
                      FROM tempTable1
                      ORDER BY [Count]
               FOR XML PATH(''), TYPE).value('.', 'nvarchar(MAX)'), 1, 1, '');

SELECT @Columns;


(No column name)


 [Mrs.], [Sra.], [Sr.], [Ms.], [Mr.]