mysql面试题（笔试）
答案：
SELECT
ANY_VALUE ( max( id ) ),
ANY_VALUE ( NAME ),
count( * )
FROM
`test`
GROUP BY
NAME,
number
SELECT
ANY_VALUE ( max( id ) ),
ANY_VALUE ( NAME ),
count( * )
FROM
`test`
GROUP BY
NAME,
number