Running sum per year, account and id

$10-30 USD

Completed

Posted

over 10 years ago

$10-30 USD

Paid on delivery

Hello I need support the create a view or an sql (MySQL) for an existing table. The query must calculate the balance (running sum) per year, account and id. I have allread the query for the balance calculation. I can not get the calculatio per year. I gues that is not a big issue. I can provide the existing query and the table with data. Please keep in mind that the code must be storable in MySQL. See the attached screenshot of table... Pol

MySQL

Project ID: 5395235

About the project

16 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@aneeshtclt

A proposal has not yet been provided

$10 USD in 1 day

5.0

(22 reviews)

5.2

16 freelancers are bidding on average $19 USD for this job

@codetod

Hi It should be just a matter of adding year(datum) in the group by clause. I might not even need the table data, will just need the existing SQL. Can do it immediately and send to you Thanks Roni

$18 USD in 3 days

4.9

(21 reviews)

4.7

@dobreiiita

simple query needs 5-10 minutes to deliver. Please initiate a communication so that i can deliver you with the project Thanks !!

$23 USD in 1 day

4.6

(25 reviews)

4.7

@nadeem717

Hi mplot, I am expert of mysql and oracle databases. I can fix this query issue with in no time. You can see my profile and previous reviews. Ready to start work Looking for positive response. Thanks!

$15 USD in 1 day

5.0

(4 reviews)

2.5

@vladislavzalesak

As you said this is a simple query change and i can have it done ASAP if you would provide me with the table structure and the curent query you are using. Looking forward hearing from you, hav a nice day

$25 USD in 1 day

4.8

(2 reviews)

2.6

@akasko

Hi there. I can help you to do the query per year. Please contact me by private message for further details. Best regards, Alex.

$15 USD in 1 day

5.0

(9 reviews)

2.0

@genius1990

Hi, I have studied your problem.I am quite expert in mysql. So I can assure you that I can solve this issue in provided time. Thanks.

$15 USD in 1 day

0.0

(0 reviews)

0.0

@nishmohan

A proposal has not yet been provided

$25 USD in 1 day

0.0

(0 reviews)

0.0

@zoborg

Hello there, This should be straight forward, I have placed a low bid as I'm yet to have any ratings on Freelancer (although I am advanced with Mysql). If you could give me the table and the data, the query you have completed we should be able to get this sorted ASAP. Kindest regards Peter Moran

$15 USD in 1 day

0.0

(0 reviews)

0.0

@elohimtenorio

I can make a view for your requirement the same day when you agree my bid I need the relationed tables and the balance calculation

$15 USD in 1 day

0.0

(0 reviews)

0.0

@noelparicollo

15 years experience in Databases. Optimization, Migration, Design, Fault Tolerance, Automatic script Generation. That's me.

$25 USD in 1 day

0.0

(0 reviews)

0.0

@dhirajDT

I am a database developer working in Database system management. I have experience of working in MS-SQL,Orcale and ETL applications along with the automation of ETL processes What you can expect from me : 1. Completely bug free solution 2. Clean and documented code 3. project completion in time 4. Post delivery service I have understood your requirement as per your statement and I can develop the app as per your need. I guarantee you fast and efficient solution development to your need ! with complete peace of mind ! :)

$20 USD in 1 day