熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

oracle時間查詢

2013-11-13 22:23:23  來源: 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


From:http://tw.wingwit.com/Article/program/Oracle/201311/18962.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.