Answers for "group by time oracle sql"

oracle sql group by date year

SELECT value1, extract(YEAR FROM my_date)
FROM my_table
GROUP BY value1, extract(YEAR FROM my_date);

oracle sql group by date year

Select count(1), country_of_sale, to_char(datefield, 'YYYY-MM') AS yyyymm
from table 
where country_of_sale IN ('USA', 'EUROPE', 'ASIA')
group by country_of_sale, to_char(datefield, 'YYYY-MM')
order by to_char(datefield, 'YYYY-MM');

group by time oracle sql

/*     DANIEL MOMBEYNI      */
SELECT M.YYYYMMDD,
       M.HH24,
       M.HALF_PART,
  FROM (SELECT TO_CHAR(T.TIME_FIELD,
                       'yyyy/mm/dd') AS "YYYYMMDD",
               TO_CHAR(T.TIMESTAMP, 'HH24') AS "HH24",
               CASE
                WHEN TO_CHAR(T.TIME_FIELD, 'MI') BETWEEN 0 AND 30 THEN
                 '0-30 min'
                WHEN TO_CHAR(T.TIME_FIELD, 'MI') BETWEEN 31 AND 59 THEN
                 '31-59 min'
               END AS "HALF_PART"
          FROM TBL_NAME T) M
 GROUP BY M.YYYYMMDD, M.HH24, M.HALF_PART
 ORDER BY 1