题目如下:
解题如下:
SELECT university, count(id) as cnt,
group_concat(distinct device_id order by id asc separator ';') as device_list
from user_profile
group by university
having cnt<=2
题目如下:
解题如下:
SELECT university, count(id) as cnt,
group_concat(distinct device_id order by id asc separator ';') as device_list
from user_profile
group by university
having cnt<=2