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