Skip to main content
Code Golf

Return to Answer

deleted 4 characters in body
Source Link
t-clausen.dk
t-clausen.dk
  • 3.8k
  • 12
  • 16

T-SQL, 172168 bytes

SELECT STRING_AGG(c,'')WITHIN GROUP(ORDER BY
x)FROM(SELECT substring(@,number,1)x,sum(1)c
FROM spt_values WHERE type='P'GROUP BY(SELECT substring(@,number,1)x FROM spt_values WHERE'P'=type)x
GROUP BY x)x WHERE x like'[a-z]'

Try it onlineTry it online

This will work for input fewer than 2048 characters. The output is ordered according to the position of the letter in the alphabet

T-SQL, 172 bytes

SELECT STRING_AGG(c,'')WITHIN GROUP(ORDER BY
x)FROM(SELECT substring(@,number,1)x,sum(1)c
FROM spt_values WHERE type='P'GROUP BY substring(@,number,1))x
WHERE x like'[a-z]'

Try it online

This will work for input fewer than 2048 characters. The output is ordered according to the position of the letter in the alphabet

T-SQL, 168 bytes

SELECT STRING_AGG(c,'')WITHIN GROUP(ORDER BY
x)FROM(SELECT x,sum(1)c
FROM(SELECT substring(@,number,1)x FROM spt_values WHERE'P'=type)x
GROUP BY x)x WHERE x like'[a-z]'

Try it online

This will work for input fewer than 2048 characters. The output is ordered according to the position of the letter in the alphabet

deleted 13 characters in body
Source Link
t-clausen.dk
t-clausen.dk
  • 3.8k
  • 12
  • 16

T-SQL, 172 bytes

SELECT STRING_AGG(c,'')WITHIN GROUP(ORDER BY
x)FROM(SELECT substring(@,number,1)x,sum(1)c
FROM spt_values WHERE type='P'GROUP BY substring(@,number,1))x
WHERE x like'[a-z]'

Try it online

This will work as long as thefor input lessfewer than 2048 characters. It does order theThe output is ordered according to the position of the letter in the alphabet

T-SQL, 172 bytes

SELECT STRING_AGG(c,'')WITHIN GROUP(ORDER BY
x)FROM(SELECT substring(@,number,1)x,sum(1)c
FROM spt_values WHERE type='P'GROUP BY substring(@,number,1))x
WHERE x like'[a-z]'

Try it online

This will work as long as the input less than 2048 characters. It does order the output according to the position of the letter in the alphabet

T-SQL, 172 bytes

SELECT STRING_AGG(c,'')WITHIN GROUP(ORDER BY
x)FROM(SELECT substring(@,number,1)x,sum(1)c
FROM spt_values WHERE type='P'GROUP BY substring(@,number,1))x
WHERE x like'[a-z]'

Try it online

This will work for input fewer than 2048 characters. The output is ordered according to the position of the letter in the alphabet

Source Link
t-clausen.dk
t-clausen.dk
  • 3.8k
  • 12
  • 16

T-SQL, 172 bytes

SELECT STRING_AGG(c,'')WITHIN GROUP(ORDER BY
x)FROM(SELECT substring(@,number,1)x,sum(1)c
FROM spt_values WHERE type='P'GROUP BY substring(@,number,1))x
WHERE x like'[a-z]'

Try it online

This will work as long as the input less than 2048 characters. It does order the output according to the position of the letter in the alphabet