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
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
A quick guess, or at least a starting point:
SELECT key, data
FROM myTable
GROUP BY key
LIMIT 2
HTH,
Arthur
On Sat, Dec 3, 2011 at 11:41 AM, Blog Tieng Viet wrote:
> Hellow everybody.
>
> I have a problem difficult for me, please give me an advice.
>
> I want to get a specific number of entry (
Hellow everybody.
I have a problem difficult for me, please give me an advice.
I want to get a specific number of entry (rows) from a table
by each Key. If the number is 1, I can use "select dinstinct",
but the number is not 1, I don't know how to select.
For example:
Key 0 | data 0-0
Key 0 |