Oracle Group By on Date Column

Oracle Group By on Date Column

          Group by clause is used to aggregate data.

Suppose Orders table has following fields

SQL> desc orders
 Name                                      Null?    Type
 ----------------------------------------- -------- ---------------------
 ORDERID                                   NOT NULL NUMBER(10)
 CUSTOMERID                                         NCHAR(5)
 EMPLOYEEID                                         NUMBER(10)
 ORDERDATE                                          DATE
 REQUIREDDATE                                       DATE
 SHIPPEDDATE                                        DATE
 SHIPVIA                                            NUMBER(10)
 FREIGHT                                            NUMBER(19,4)
 SHIPNAME                                           NVARCHAR2(40)
 SHIPADDRESS                                        NVARCHAR2(60)
 SHIPCITY                                           NVARCHAR2(15)
 SHIPREGION                                         NVARCHAR2(15)
 SHIPPOSTALCODE                                     NVARCHAR2(10)
 SHIPCOUNTRY                                        NVARCHAR2(15)

Group by on  Date

select orderdate,count(*) from orders

group by orderdate;

GROUP BY On YEAR

select to_char(orderdate,'yyyy'),count(*) from orders
group by to_char(orderdate,'yyyy')

Group By on Year ,Month

select to_char(orderdate,'yyyy'),to_char(orderdate,'MON'),count(*) from orders
group by to_char(orderdate,'yyyy'),to_char(orderdate,'MON')
order by 1,2

Tags:  Oracle Group By , Oracle Group by Date,Oracle Group by Year,Oracle Group by Month,

How to use group by clause on Date column, Oracle Group By on Date Column