Charts: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) (Created page with " Examples: # Northwind Orders table SQL select EXTRACT(month from TO_DATE("OrderDate",'MM')) AS "MON", TO_CHAR(TO_DATE("OrderDate",'MM/DD/YYYY'), 'Month') AS "Month", SUM(1) from orders group by EXTRACT(month from TO_DATE("OrderDate",'MM')) , TO_CHAR(TO_DATE("OrderDate",'MM/DD/YYYY'), 'Month') order by EXTRACT(month from TO_DATE("OrderDate",'MM'))") |
(No difference)
|
Revision as of 12:46, 10 August 2022
Examples:
- Northwind Orders table
SQL
select EXTRACT(month from TO_DATE("OrderDate",'MM')) AS "MON", TO_CHAR(TO_DATE("OrderDate",'MM/DD/YYYY'), 'Month') AS "Month", SUM(1)
from orders
group by EXTRACT(month from TO_DATE("OrderDate",'MM')) , TO_CHAR(TO_DATE("OrderDate",'MM/DD/YYYY'), 'Month')
order by EXTRACT(month from TO_DATE("OrderDate",'MM'))
