Fix SQL to sort by month. (script to show count on agreements each month)
select to_char(date_start,'mon yyyy') AS ds, count(id) AS count from t_agreements
WHERE date_start IS NOT null
GROUP BY to_char(date_start,'mon yyyy')
Do not change output data
ds: (3 first letter in month + yyyy), count: (number of records)
12 freelancere byder i gennemsnit €22 på dette job
I have done projects with PostgreSQL to upload data from XL to mySql Db as well as zinking data with c#.net environment. I have more than one year experience working with PostgreSQL and maintaining queries.