select tuserid count(tid) num
from sso_access_log t
where =
and taccess_time >= to_date( yyyyMMdd )
and taccess_time <= to_date( yyyyMMdd )
group by tuserid
order by num desc
