select 重复字段, count(重复字段) from 表 group by 重复字段 order by 重复字段 desc
select lastlogonIP, count(lastlogonIP) as col1 from usertable group by lastlogonIP order by col1 desc
我实际情况是usertable用户注册表.有人ip重复注册的统计.
select 重复字段, count(重复字段) from 表 group by 重复字段 order by 重复字段 desc
select lastlogonIP, count(lastlogonIP) as col1 from usertable group by lastlogonIP order by col1 desc
我实际情况是usertable用户注册表.有人ip重复注册的统计.