`

atf通过机票提交时间分析系统使用情况

 
阅读更多

select to_char(t.entry_time,'yyyy-mm-dd hh24') "时间",to_char(t.entry_time,'day','NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE''') "星期" ,count(1) "数量" from atfa.t_ticket@maspos_201.source
where to_char(t.entry_time,'yyyy-mm')='2009-05'
 group by  rollup(to_char(t.entry_time,'yyyy-mm-dd hh24')) ,to_char(t.entry_time,'day','NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE''')order by count(1) des

 

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics