Create a SQL (complex) query

Completed Posted Nov 12, 2015 Paid on delivery
Completed Paid on delivery

I have a database with one table. One of the fields in the table contains a lot of data in JSON format.

I need a query that selects the latest entry of every customer in the table (most customers have more than one entry) and populates and extracts some data out the JSON data.

MySQL SQL

Project ID: #8892644

About the project

29 proposals Remote project Active Nov 19, 2015

Awarded to:

superitz

I am highly proficient in writing SQL queries.

$15 USD in 1 day
(1 Review)
0.4

29 freelancers are bidding on average $25 for this job

axiomswb

I have yet not check your attached file... I think I can provide quality of service in SQL, MySQL.. Please communicate.. Thank you..

$25 USD in 1 day
(50 Reviews)
6.9
pakulin

Hi. What mysql version do you use? Describe row manipulation need to be performed .

$30 USD in 1 day
(24 Reviews)
5.1
sergioeliot3

Hi! I can help you writting the query that you require. Please let me know if interested, I will be glad to help you. Best Regards. Eliot

$40 USD in 1 day
(32 Reviews)
5.5
khannanav

We have a team of expert DB developers with more than 9 years of rich industry experience and would be more than happy to work on this project. We have expertise in writing complex queries to fetch various types of More

$40 USD in 2 days
(11 Reviews)
4.5
hassanalvi95

Let me know i can do this in max 1 hour ... Thanks have a good day ... Let me know if you are interested ...

$20 USD in 1 day
(5 Reviews)
4.2
manionweb

Dear sir, Please show me your database and tables so that i can check the data base and generate query which will pull latest entry among json data. Thanks & regards

$25 USD in 1 day
(6 Reviews)
4.0
data0expert

I am an expert in the data field. I have worked on different databases project. I do lots of works using SQL to generate report and filter data. I also work on big data warehousing projects that include cleansing data More

$35 USD in 1 day
(1 Review)
4.0
vishaltile

We are SQL professionals and we will deliver you in less time with quality for sure.

$25 USD in 1 day
(12 Reviews)
3.9
vw7504937vw

Over the last 3+ years, i am handling national and international project. I hope to bind good relation with more many is always the FIRST of my all works. I'm here and will do best for Visions: High Quality, High S More

$20 USD in 1 day
(1 Review)
1.7
praks0000

have experience in MySQL and SQL for more than 2 years. Have worked on handling Large objects in Database.

$25 USD in 1 day
(0 Reviews)
0.0
ReeshmaSajeevan

A proposal has not yet been provided

$20 USD in 2 days
(0 Reviews)
0.0
tcunn093

I have real world experience using SQL, and can get the job done. My SQL capabilities are available for comparison on my github.

$35 USD in 2 days
(0 Reviews)
0.0
krameru

Hi Which data you need from JSON string? What is the name of the JSON data field? What is the name of the customer id field? These are all questions you need to answer. Then I can provide a query for this.

$25 USD in 2 days
(0 Reviews)
0.0
VishalAmrutiya

A proposal has not yet been provided

$20 USD in 1 day
(0 Reviews)
0.0
softingbosnia

We do have a lot of experience in working with databases in general, especially in mysql. We have created dozens application which include working with databases and we also use json format frequently in our applicatio More

$25 USD in 1 day
(0 Reviews)
0.0
akizadyanrojo

I'll provide the code an hour i already have the source code , i'll just need to see your table / json file to fit on your need

$20 USD in 1 day
(0 Reviews)
0.0
raushan1info

A proposal has not yet been provided

$27 USD in 1 day
(0 Reviews)
0.0
robertshui84

I have been using SSMS for my full time job for the past years. I have created reports for campaigns result, company reports for budgeting and data integrity reports etc. Please contact me to discuss further.

$20 USD in 2 days
(0 Reviews)
0.0
mirzamb

A proposal has not yet been provided

$35 USD in 3 days
(0 Reviews)
0.0
harivinod007

I have done the same before.

$15 USD in 1 day
(0 Reviews)
0.0