postgresql command current year

$10-30 USD

Teljesítve

Kiadva ekkor:

körülbelül 7 évvel ezelőtt

$10-30 USD

Teljesítéskor fizetve

need correct postgresql command command before select max(invoice_number) from invoice where published=1 AND type=1 AND my_company_id =46 but i need max(invoice_number) from only current year i tried select max(invoice_number) from invoice where published=1 AND type=1 AND my_company_id =46 and [login to view URL] >= EXTRACT(YEAR FROM CURRENT_DATE) but it not works

PostgreSQL

Projektazonosító: 13555979

A projektről

14 ajánlat

Távolról teljesíthető projekt

Aktiválva: 7 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@user318

Hi. I can help you with this. I am writing complex queries in postgres sometimes and have good experience of dealing with its documentation. Do you get an error on your query or it returns unexpected results? I do not know how your table is defined, but I suppose you have an error.

$15 USD 1 napon belül

5,0

(1 értékelés)

0,0

14 szabadúszó adott átlagosan $22 USD összegű árajánlatot erre a munkára

@nguyenquanglong

Hi client. Can you give the sample data and full command. I can help you solve it quick. Don't be hesitate contact to me.

$30 USD 1 napon belül

5,0

(2 értékelés)

0,0

@millanmalla

As per the requirement by the client he/she needs to change/review the sql query with an expert. So I will guide/demonstrate the sql part to the client for their better understand.

$23 USD 1 napon belül

0,0

(0 értékelés)

0,0

@kienngd

Dear sir, please send me struct of your table then I resend you the SQL command.

$30 USD 1 napon belül

0,0

(0 értékelés)

0,0

@slsjunior

simple orientaria about PostgreSQL

$35 USD 1 napon belül

0,0

(0 értékelés)

0,0

@devarepradip

A proposal has not yet been provided

$15 USD 2 napon belül

0,0

(0 értékelés)

0,0

@ningappakanavi

I thought it would be great pleasure to me to work with you, I will provide better solution for you. It would be great if you give this opportunity to me. Thanks in Advance :)

$15 USD 1 napon belül

0,0

(0 értékelés)

0,0

@gamish215

I have a Sound Knowledge on PostgreSQL ,Worked on client/Server ,Replication and PGdumps, can tackle the simple ans complex query with performance improvement plan at planner side .

$25 USD 1 napon belül

0,0

(0 értékelés)

0,0

@talkadah

Hello, I am expert in database, and specially in postgres. I don't know if the problem has been resolved. but I can fixed very quickly for you. I had have several challenges with dates and postgres Kind regards, Tarek

$10 USD 1 napon belül

0,0

(0 értékelés)

0,0

@davedcb

Hello, I am interested in your project. I am a software engineer and I have professional experience with PostgreSQL. Thank you, Best regards, David

$25 USD 0 napon belül

0,0

(0 értékelés)

0,0

@rmendoza83

Hi, I am Reinaldo Mendoza, Computer Engineer with more than 12 years of experience in the career, I work with databases in PostgreSQL, MySQL, Firebird, MS Access, SQL Server, among others, I have language mastery SQL. I am at your disposal. Greetings.

$25 USD 1 napon belül