Answer the question
In order to leave comments, you need to log in
How to leave only letters in the selection?
There is a table in which one column is headings. I would like to make a series of all the first unique letters.
I do it like this:
select distinct *
from (
select substr(title, 0, 2) as charters
from posts) as list
order by charters asc;
"
(
1
4
5
E
I
R
S
T
«
А
Б
В
Д
Е
Ж
З
И
К
Л
М
Н
О
П
Р
С
Т
У
Ф
Х
Ц
Ч
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question