cjbqyj的博客

原创 mysql计算某一列有哪些数据于每个数据的个数

mysql计算某一列有哪些数据于每个数据的个数计算mysql中某一列数据有哪些，去掉重复的mysql例如：原始表原始表select name from testbook group by name;计算某一列的数据不重复的值，并且计算个数；SELECT name count( * ) AS COUNT FROM testbook GROUP BY name ORDER BY COUNT DESC;...