SQL Duplicated Records

$10-30 USD

Closed

Posted

almost 2 years ago

$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

Database Administration

Project ID: 33993418

About the project

33 proposals

Remote project

Active 2 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

33 freelancers are bidding on average $23 USD for this job

@Truonggiang86

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 response if interested. Thank you!!!

$50 USD in 1 day

5.0

(57 reviews)

6.3

@BitLabs

Hello, I have gone through your outsourced requirements " SQL Duplicated Records " and have analyzed that I have right skills ( SQL Oracle MySQL Database Administration Microsoft SQL Server ) to execute your esteemed project. I will complete your project today, LIFETIME error free guarantee and provide 365 days (ONE YEAR) support... ===== Why choose me? ===== 5.0 / 5.0 rating, 100% completion rate, 100% on-time completion, 100% on-budget :) Kindly, check my profile: http://www.freelancer.com/u/BitLabs.html I work smart, hard, and strictly bid only what we can do! No sub-contracting... ever! You will never go wrong choosing me :)

$20 USD in 7 days

5.0

(47 reviews)

6.0

@erranjit28111989

Hello i can duplicate this mysql Recodes which is about 10k Let's discuss once Pro coder --Ranjit.....................

$88 USD in 1 day

5.0

(56 reviews)

5.6

@Sugidev

Hi there I am an sql expert. I have the solution for you problem. Please message me, I will share the solution. Thanks Suguna

$45 USD in 1 day

4.9

(32 reviews)

5.2

@Hasnain136

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

$20 USD in 1 day

5.0

(33 reviews)

4.6

@Shakerfawzy

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 for your time and consideration. Best Regards, Shaker

$15 USD in 1 day

5.0

(17 reviews)

4.4

@TEKSCENT

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

$75 USD in 1 day

5.0

(21 reviews)

4.4

@noureen23

============Duplicate Data======================= Good Morning, I have seen your requirement to Design Query as per given details of columns and conditions . ************************************ ITS DONE, Ping me back, so I can forward THE SOLUTION FILE :) ********************************* Best regards, Thanks!!!

$10 USD in 1 day

5.0

(19 reviews)

4.1

@fredavinci

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..

$30 USD in 7 days

5.0

(4 reviews)

3.6

@jegaonline

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 you need. Please chat me to start on this. I am looking forward to working with you. Thank You

$20 USD in 1 day

4.9

(4 reviews)

3.3

@bbbssolutions

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.

$20 USD in 1 day

4.9

(20 reviews)

3.5

@CourserXu

Possess extensive knowledge of SQL along with its variation for popular database like Microsoft SQL server, DB2 and Oracle 12c Expertise in writing simple/complex queries, and optimizing SQL statements for various projects to ensure it gives the desired output In-depth information of relational databases, and adept in maintaining them by frequently checking requirements to keep them updated Familiar with the entire software development life-cycle, and capable of participating in each phase to deliver quality product to clients and building healthy professional relations

$20 USD in 7 days

5.0

(2 reviews)

2.9

@SubhashiniTr

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 details! Regards, Subhashini T R

$10 USD in 7 days

5.0

(1 review)

2.7

@zcollins

Hello, I'm an experienced developer who is knowledge about SQL. I can help you write a SQL SELECT statement to find all duplicate values by the conditions which you gave. I can have it done in half of an hour. Thank you for your time.

$15 USD in 1 day

0.0

(0 reviews)

0.0

@yasmineshaker88

Dear sir, I have done the query based on you sample data .please send to me so I send the query for you thanks

$10 USD in 1 day

0.0

(0 reviews)

0.0

@kratikaSoni11

Senior Software Engineer with thorough hand on experience in sql developing and java developing It will be fun working in sql

$10 USD in 1 day

0.0

(0 reviews)

0.0

@yangtianhua

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.

$10 USD in 1 day

0.0

(0 reviews)

0.0

@amraniamine1999

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 reviews ;) Regards

$10 USD in 7 days

0.0

(0 reviews)

0.0

@ravisamal

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

$20 USD in 7 days

0.0

(0 reviews)

0.0

@softengineer2006

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 as Oracle, MySQL and MS SQL Server

$20 USD in 7 days