我在mysql中有个表,格式如下:varchar ipaddr;
date time;具体内容如下:
192.168.0.1 2011-05-20
192.168.0.1 2011-05-20
192.168.0.1 2011-05-20
192.168.0.1 2011-05-20
192.168.0.1 2011-05-20
192.168.0.2 2011-05-20
192.168.0.2 2011-05-20
192.168.0.2 2011-05-20
192.168.0.3 2011-05-20
192.168.0.3 2011-05-20
……
192.168.0.30 2011-05-20我怎么取出这一天里,出现次数最多的10条IP地址(每条IP地址个数不一定)
谢谢~
date time;具体内容如下:
192.168.0.1 2011-05-20
192.168.0.1 2011-05-20
192.168.0.1 2011-05-20
192.168.0.1 2011-05-20
192.168.0.1 2011-05-20
192.168.0.2 2011-05-20
192.168.0.2 2011-05-20
192.168.0.2 2011-05-20
192.168.0.3 2011-05-20
192.168.0.3 2011-05-20
……
192.168.0.30 2011-05-20我怎么取出这一天里,出现次数最多的10条IP地址(每条IP地址个数不一定)
谢谢~
group by ipaddr
order by cn desc limit 10;