Ask a mysql question

Ask a mysql question. a table first extracts the groupid that meets the condition and then uses this groupid to retrieve the data in the table. You can use mysql to retrieve a table .. Don't ask for anything else ., SQLcodeSELECT * FROMtable_nameWHEREgid: Ask a mysql question.
A table first extracts the groupid that meets the conditions, and then uses the groupid to retrieve the data in the table.
You can use mysql to retrieve a table .. Do not ask for anything else.

------ Solution --------------------

SQL code

SELECT * FROM table_name WHERE gid IN (SELECT * FROM (SELECT gid FROM table_name group by gid limit 10) t)