一般distinct就可以,运行时间:53ms,占用内存:7544kb 其实group by也可以,运行时间:38ms,占用内存:6740kb
#SELECT DISTINCT university from user_profile
SELECT university FROM user_profile GROUP BY university
一般distinct就可以,运行时间:53ms,占用内存:7544kb 其实group by也可以,运行时间:38ms,占用内存:6740kb
#SELECT DISTINCT university from user_profile
SELECT university FROM user_profile GROUP BY university