Group by (first letter)
Database
3
Posts
2
Posters
0
Views
1
Watching
-
Hello, in some table, how can i perform a group by not by the column string but only by the letter of that column thanks :-D
nelsonpaixao@yahoo.com.br trying to help & get help
-
Hello, in some table, how can i perform a group by not by the column string but only by the letter of that column thanks :-D
nelsonpaixao@yahoo.com.br trying to help & get help
Yes.
GROUP BY SUBSTR([COLUMN], 1, 1)
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
-
Yes.
GROUP BY SUBSTR([COLUMN], 1, 1)
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
thanks :-D
nelsonpaixao@yahoo.com.br trying to help & get help
