oracle时间查询

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