Find Jobs
Hire Freelancers

Compare two table data in MySQL

₹600-1500 INR

Closed
Posted over 3 years ago

₹600-1500 INR

Paid on delivery
Need this accomplished only in MySQL. Below is the high level requirement. Refer attachments for more details on requirement, table structure, before/after comparison sample result set etc. • Need a query/SP to compare the data of table1 and table2 • If a record in table1 has only one match found in table2 --> table1.ref_id = table2.rec_id, comp_result = 'Match' • If a record in table1 has multiple matches found in table2 --> table1.ref_id = table2.rec_id of the first match where table2.rec_id doesn't exist in table1.ref_id, comp_result = 'Match' • Value of ref_id should be unique.
Project ID: 27483677

About the project

9 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

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
9 freelancers are bidding on average ₹1,350 INR for this job
User Avatar
Hi, nice to greet you, my name is Alex, I would be interested in working on your project, I have immediate availability, I have great knowledge in MySQL I remain attentive to your comments Regards
₹800 INR in 1 day
5.0 (152 reviews)
6.3
6.3
User Avatar
I can develop a query to compare a two tables according to described requirements. I am highly qualified Senior SQL developer and I have a more than 10 years of professional experience.
₹3,000 INR in 1 day
5.0 (56 reviews)
5.5
5.5
User Avatar
I am a full-stack developer with a career in the IT industry of over 4 years. I have rich experiences with many people and they always get the best result. It's a piece of cake for me! You'll not waste your GOLD TIME. I readed through the job details extremely carefully and It's very easy for me. Can we have quick chat right now so that we can discuss the project briefly? Please give me a chance to work as your on-going partner! I will do everything in my power to assist you Regards.
₹1,050 INR in 1 day
5.0 (27 reviews)
4.5
4.5
User Avatar
Greeting!!! I reviewed your requirement, I am Oracle Certified Data Scientist,Analyst Professional having over 5+ years experience in Database development covering multiple technologies like oracle, mysql,sql plsql. I would like to work in this project, I will continue to work with you till you satisfy with my work. Thanks Kundlik R
₹600 INR in 1 day
5.0 (1 review)
1.0
1.0
User Avatar
Hi Sir! It's a pleasure to meet you. I'd really like to work with you on this one if possible! I am a new developer here, but have much experience in web development. Looking through your attachment, I clearly got to know what you want to. I can complete your project on time. Please give me the chance and that would be my pleasure. I am ready to discuss details about your project. Looking forward to hearing from you. Regards, Serghei.
₹1,500 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 6 year of experience in database development , i am pro with query optimization and SP writing .
₹1,200 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Your query is resolved, I have 10 year of experience working in database. i will provide you query within 15 mints and also do some change on same day if required.
₹1,000 INR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Coimbatore, India
4.7
6
Payment method verified
Member since Feb 24, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.