SQL Duplicated Records
$10-30 USD
Paid on delivery
There are more than 10k sql records and some records are duplicated i want to learn which records duplicated regarding below conditions
Conditions
If [login to view URL] = [login to view URL]
and
[login to view URL] = [login to view URL]
and
[login to view URL] = [login to view URL]
and
[login to view URL] – [login to view URL] <= 95 days
and
[login to view URL] <= 1,5
TABLE
Column1 | column2 | column3 | column4 | column5
Row1 | 8800 | pencil | 1234 | 2022-05-05 | -658,5
Row 2 | 8800 | pencil | 1234 | 2022-04-05 | -655,5
Row 3 |8800 | pencil | 1234 | 2021-04-05 | -650
RESULT
Row1 | 8800 | pencil | 1234 | 2022-05-05 | -658,5
Row 2 | 8800 | pencil | 1234 | 2022-04-05 | -655,5
Project ID: #33993418
About the project
33 freelancers are bidding on average $23 for this job
hello there, to find the duplicate base on the specific condition we can use the group by statement and having count >1 to find which one is duplicated. Pls share me your requirement so we can discuss. Waiting for your More
Hello i can duplicate this mysql Recodes which is about 10k Let's discuss once Pro coder --Ranjit.....................
Hi there I am an sql expert. I have the solution for you problem. Please message me, I will share the solution. Thanks Suguna
Hi Sir, I can do SQL Duplicated Records task. Ready to start now I have seen your job requirements and I am sure that I can do your task efficiently in less timeline as I am an expert SQL developer Thank, Hasnain
Hi, I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions , SAN Storage and Backup Solutions Thank you More
I have around 12+ years of professional experience in sql development in oracle/Db2/mysql/sqlserver. I have worked in more than 300 projects. Lets discuss your requirements
Am an sql expert with 8+ years, i can create a match_recognize query to rid the duplicates. lets link up on chat. looking forward to working with you..
Hello, Please give me a chance. I can do this for you and give results more than you are expected. You can use GROUP BY and HAVING COUNT keywords in SELECT Statement to get the Duplicate Values with whatever details More
Hi, I have 1. 11 Years of experience 2. Expert in ASP.net,C#.net,VB.net,Sql server,PHP,MySql,MS Access,Crystal Report 3. Worked in almost 250+ projects. 4. Dedication, timely execution and perfection is our key Skill.
Hello! I can create a simple application using C# to compare the SQL records and display the duplicate records according to the given conditions. If you are interested, please reach out to me to discuss further detai More
Dear sir, I have done the query based on you sample data .please send to me so I send the query for you thanks
Senior Software Engineer with thorough hand on experience in sql developing and java developing It will be fun working in sql
hello. it is an easy work. you already wrote the answer based on your condition. i can help for this however the payment it is.
Hey, I worked a lot with SQL using ORACLE so I think I can help you. The problem seems not to be such difficult! I keep the price low because I ve just started working with freelancer, so I need projects and revie More
Hi I've been working on SQL server from past 2 years I can help you with this solution . Looking forward to connect with you
Hi, I am experienced software professional with more than 15 years of experience in design and development of software applications. I am well conversant in writing advanced SQL/PL SQL queries on well know RDBMS such More