Re: How to get a specific number of entries per one key ?

[Rik Wasmus]

Taking the question _very_ literal:

> A quick guess, or at least a starting point:
> 
> SELECT key, data

, SUBSTRING_INDEX(GROUP_CONCAT(data ORDER BY data SEPARATOR ','),',',2)

> FROM myTable
> GROUP BY key

<remove limit here>
-- 
Rik Wasmus