Kapalı

SQL Duplicated Records

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

Beceriler: SQL, Microsoft SQL Server, MySQL, Oracle, Veri Tabanı Yönetimi

Müşteri Hakkında:
( 1 değerlendirme ) Amsterdam, Netherlands

Proje NO: #33993418

Bu iş için 36 freelancer ortalamada $25 teklif veriyor

(113 Değerlendirme)
5.9
(44 Değerlendirme)
5.8
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 est Daha Fazla

$20 USD in 7 gün içinde
(42 Değerlendirme)
5.9
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(54 Değerlendirme)
6.0
erranjit28111989

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(55 Değerlendirme)
5.6
(44 Değerlendirme)
5.6
(49 Değerlendirme)
5.1
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(31 Değerlendirme)
5.2
maheshbhatnagar

Hi Dear ! I have read your requirement. I can do it. I can complete your project on time and within your budget. Skills : PHP/MySQL, Codeigniter, Angular, Html5/css3, Javascript, Jquery, ajax, nodejs, php Previous Daha Fazla

$20 USD in 7 gün içinde
(20 Değerlendirme)
4.3
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(28 Değerlendirme)
4.5
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(21 Değerlendirme)
4.4
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(13 Değerlendirme)
4.2
(12 Değerlendirme)
4.0
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(20 Değerlendirme)
3.5
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 gün içinde
(3 Değerlendirme)
3.5
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
3.3
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 detai Daha Fazla

$10 USD in 7 gün içinde
(1 Yorum)
2.7
swaroopy

Hi, I have very good experience in writing SQL. we can use duplicate query and find the duplicates as per the above requirement. Please ping me so that we can discuss more on out project. I am ready to start right awa Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
2.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 ba Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
2.3
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 y Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0