PostgreSQL script

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)

Evner: Database Administration, PostgreSQL, SQL

Se mere: simple delete query sql php, simple ajax postgresql query, blogspotcom simple ajax website backend sql, shell script to insert data in postgres, psql script example, postgresql scripting, postgresql script example, postgresql script tutorial, how to write postgresql script, postgresql script declare variable, run postgresql script, sql, database administration, database development, database programming, postgresql, fix sql connection, enhance pages builds simple search query, query snmp sql, php fix sql xss function

Om arbejdsgiveren:
( 4 bedømmelser ) Stavanger, Denmark

Projekt ID: #16477585

Tildelt til:


Hi I'm expert in Postgres SQL Please give me an opportunity, I will do it perfectly.

€8 EUR på 1 dag
(1 bedømmelse)

11 freelancere byder i gennemsnit €22 på dette job


Hi, I have good proficiency in sql. I would like to sort this query by month keeping the same output. Regards, Manish

€12 EUR på 1 dag
(48 bedømmelser)

A proposal has not yet been provided

€29 EUR på 1 dag
(6 bedømmelser)

I have been working as Senior DBA for last 6 years and having very good experience in core DBA related tasks in Oracle,MySQL and PostgreSQL databases like Installation, implementing RAC with ASM, Configuring Data Guard Flere

€30 EUR in 0 dage
(2 bedømmelser)

hello how are you I hope you are good, I have good experience in this part with postgres tego the solution to your problem I am available to help you hire me and I will do the work for you I know it will be satisfactor Flere

€23 EUR på 1 dag
(3 bedømmelser)

A proposal has not yet been provided

€22 EUR på 1 dag
(1 bedømmelse)
€23 EUR på 1 dag
(0 bedømmelser)

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.

€34 EUR in 25 dage
(0 bedømmelser)

A proposal has not yet been provided

€23 EUR på 1 dag
(0 bedømmelser)

Hello, I reviewed your SQL Script and I already have a solution for you. With the modified SQL script you will get results sorted by month (for each year). And as you mentioned output data will not be changed, it Flere

€10 EUR på 1 dag
(0 bedømmelser)

A proposal has not yet been provided

€24 EUR in 2 dage
(0 bedømmelser)