SQL

Tips on Oracle SQL

How to get date/month/year from a date column?

`SELECT EXTRACT(month FROM order_date) "Month", COUNT(order_date) "No. of Orders" FROM orders GROUP BY EXTRACT(month FROM order_date) ORDER BY "No. of Orders" DESC;`

Source :Click Here