--- robert.ci...@gmail.com wrote:
> I am still curious to know if there is a purely SQL way to do the same.
This can be achieved using group_concat:
select div,
rtrim (substr (s, 1, 10)) nr1,
rtrim (substr (s, 1, 10)) nr2,
rtrim (substr (s, 1, 10)) nr3
from (
select div, group_concat (substr (team || ' ', 1, 10), '') AS s
from (
select div, team
from teams
order by div, wins+0 desc)
group by div);
Don't believe this is ANSI SQL though.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
