请问这条登录查询语句怎么写？

作者: kucao   发布时间: 2011-12-01

select ip,count(*) as cnt
from a
group by ip
order by cnt desc

作者: AcHerat   发布时间: 2011-12-01

作者: wang7535067   发布时间: 2011-12-01

作者: kucao   发布时间: 2011-12-01

select ip,count(*),min(logintime) as cnt
from a
group by ip
order by cnt desc

作者: qianjin036a   发布时间: 2011-12-01

select ip,count(*),max(logintime) as cnt
from a
group by ip
order by cnt desc

作者: qianjin036a   发布时间: 2011-12-01

select ip,count(*) as cnt,min(logintime) as lastlogin
from a
group by ip
order by cnt desc

作者: qianjin036a   发布时间: 2011-12-01

select ip,登录次数=count(*),最后登录时间=max(logintime) from a group by ip

作者: pengxuan   发布时间: 2011-12-01

作者: kucao   发布时间: 2011-12-01

作者: kucao   发布时间: 2011-12-01