sql查詢一天每個(gè)小時(shí)的數(shù)據(jù) oracle中怎么按每小時(shí)分組。數(shù)據(jù)如下？
oracle中怎么按每小時(shí)分組。數(shù)據(jù)如下？select time，count(time) from (select substr("2014-01-01 20:03:00"，1，13) as time
oracle中怎么按每小時(shí)分組。數(shù)據(jù)如下？
select time，count(time) from (select substr("2014-01-01 20:03:00"，1，13) as time from table_name) group by time
Oracle數(shù)據(jù)庫(kù)按時(shí)間進(jìn)行分組統(tǒng)計(jì)數(shù)據(jù)的方法？
SELECT TO_CHAR(TO_DATE(20160316，"YYYYMMDD")，"W") FROM DUAL TO_CHAR函數(shù)可以獲取某一天是在該月中的第幾周，然后可以按照這個(gè)函數(shù)來分組了