A:select access_ip,count(access_time) 登录次数 from test group by access_ip;B:select access_ip from ( select access_ip,count(access_time) times from test group by access_ip ) where times>=10;
不好意思,access_time指的是登录时间
select access_ip from test group by access_ip having count(access_ip) >= 10;
select access_ip from test group by access_ip having count(access_ip) >= 10;
select access_ip from test group by access_ip having count(access_ip) >= 10;
A:select access_ip,count(access_ip) 登录次数 from T_Access_Log group by access_ip; B:select access_ip from ( select access_ip,count(access_ip) times from T_Access_Log group by access_ip ) where times>=10;
A:select access_ip,count(access_ip) 登录次数 from T_Access_Log group by access_ip; B:select access_ip from ( select access_ip,count(access_ip) times from T_Access_Log group by access_ip ) where times>=10;
select access_ip,count(access_time) times from test group by access_ip
)
where times>=10;
select access_ip,count(access_ip) times from T_Access_Log group by access_ip
)
where times>=10;
select access_ip,count(access_ip) times from T_Access_Log group by access_ip
)
where times>=10;