9 lines
312 B
SQL
9 lines
312 B
SQL
|
|
CREATE temporary TABLE tmptable AS
|
|
SELECT DISTINCT(language) from WordScore;
|
|
|
|
select tmptable.language, (select w.word from
|
|
WordScore as w where w.language = tmptable.language
|
|
group by w.RootWord order by w.score desc limit 30
|
|
|
|
) as word from tmptable;
|