阅读背景:

如何以小时为单位从oracle数据库中获取数据

来源:互联网 

i have one table in my database say mytable, which contents request coming from other source. There is one column in this table as Time, which stores date and time(e.g. 2010/07/10 01:21:43) when request was received. Now i want to fetch the data from this table on hourly basis for each day. Means i want count of requests database receive in each hours of a day. e.g.for 1 o'clock to 2 o'clock say count is 50 ..like this.. I will run this query at the end of day. So i will get requests received in a day group by each hour.i have one table in my database say mytable, wh




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: