日期:2015-06-28 00:00:00 来源: IT猫扑网
select t.userid, count(t.id) num
from sso_access_log t
where 1 = 1
and t.access_time >= to_date('2009-10-12 ', 'yyyy-MM-dd ')
and t.access_time <= to_date('2010-11-08 ', 'yyyy-MM-dd ')
group by t.userid
order by num desc
相关文章
相关下载
网友评论