SELECt `column`, COUNT(`column`) AS `value_occurrence` FROM `my_table` GROUP BY `column` ORDER BY `value_occurrence` DESC LIMIT 1;
替换
column和
my_table。
1如果要查看列的
N最常用值，请增加。
SELECt `column`, COUNT(`column`) AS `value_occurrence` FROM `my_table` GROUP BY `column` ORDER BY `value_occurrence` DESC LIMIT 1;
替换
column和
my_table。
1如果要查看列的
N最常用值，请增加。
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
