Need Sql query for removing duplicates and fixing the relation table

Închis Postat la acum 4 ani S-au achitat serviciile după ce au fost prestate
Închis S-au achitat serviciile după ce au fost prestate

I need help to modify a sql database.

i have a "name" table which has a ManyToMany relationship to another table called "hobbies". The third table "hobbies_id_name_id" contains the relationship between name and hobbies table.

I need a sql query to fix the relationship table and delete the duplicates from the name table

name table:

id name

1 tom

2 tim

3 lisa

4 jan

5 tomas

6 tom => delete duplicate

7 lisa => delete duplicate

8 tom => delete duplicate

hobbies table:

id sports

1 football

2 tennis

3 basketball

4 cricket

5 baseball

relationshop table:

hobbiesId-----nameId

1..........................1

1..........................5

2..........................3

3..........................6 => replace with 1

3..........................4

4..........................8 => replace with 1

5..........................7 => replace with 3

5..........................8 => replace with 1

Administrare baze de date Programare baze de date MySQL SQL

ID Proiect: #19741824

Detalii despre proiect

48 propuneri Proiect la distanță Activ acum 4 ani

48 freelanceri plasează o ofertă medie de 25€ pentru proiect

sumon355

Hello, As an expert in SQL, i am very much interested to provide you the required sql query. Are you using MySQL? Looking forward to have a positive response from you. Thanks

€19 EUR în 1 zi
(246 recenzii)
7.6
codetod

Hi I am a database expert with 12 years experience in handling MS SQL and MySQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and trig Mai multe

€30 EUR în 1 zi
(81 recenzii)
6.4
bhaskarmandal

Hi, I am 8 years experienced SQL developer. I understand your point. I can complete this project within two hours . Please check my profile for my work quality . Thanks, Bhaskar Mandal

€26 EUR în 1 zi
(45 recenzii)
5.8
softcarve

Hi, I have good experience in writing SQL queries. I would like to remove duplicate and remap the ids in the table hobbies_id_name_id Available for discussion and ready to start now. Looking Forward to your response. R Mai multe

€30 EUR în 1 zi
(95 recenzii)
5.9
Mickelson

Dear my employer! I checked your project carefully. I have a deep understanding of the problems you are going to realize in your project. They are not so difficult for me with 12 years of app development years. Unt Mai multe

€100 EUR în 1 zi
(21 recenzii)
5.4
xinglong717

Hi. I've read carefully your job description I'm have a lot of experiences in JAVA, VB, .NET ,SQL QUERY, .... And I also have experiences in Excel VBA developing and data mining. If you hire me, then I will try my be Mai multe

€30 EUR în 7 zile
(36 recenzii)
5.3
ludwig333

Hello I am a sql query expert** I have already read your description in more details and have interested in your project. I can do it perfectly soonest as your requirment Thank you.

€19 EUR în 1 zi
(20 recenzii)
5.1
contactsapphire

Dear Sir, My name is Parth. I've read your brief and can see that you need SQL query for removing duplicates and fixing the relation table ***** We've passed all freelancer certifications relevant to this project. ** Mai multe

€80 EUR în 1 zi
(2 recenzii)
5.1
jayantavkumar

I am ready to work with you. Let me know if you are ready to go...Accordingly I will take above example and will provide you solution. I am a database / Business Intelligence / solution architect. I have more than 14 Mai multe

€25 EUR în 1 zi
(28 recenzii)
4.9
BestService222

Dear, Sir. Nice to meet you. I read your project description carefully and am very interested in working for your project. I am able to provide the best product with awesome and good performance and offer a good resu Mai multe

€25 EUR în 1 zi
(10 recenzii)
5.1
PATechnology

Hi, I am interested in the task and have an experience in it. please ping me to discuss more. thanks

€9 EUR în 1 zi
(30 recenzii)
4.5
sreenivas2903

Hi i am expertise in sql query and warehousing i would like to resolve ur problem in notnkore than 1 hour if you are interested ping me

€34 EUR în 1 zi
(17 recenzii)
4.5
tausy

Hi, I'm a data engineer with over 5 years of experience developing data-centric applications using SQL, PL/SQL, and many other tools. I can complete this work within a few hours with 100% precision and quality. I'm Mai multe

€30 EUR în 0 zile
(12 recenzii)
4.3
onlydarshit

I am expert in desiging databases specially with Oracle, MySql and Ms access. I have hands on experience working in the same databases for more than 4+ years. I can easily design Triggers, procedures and others objects Mai multe

€8 EUR în 1 zi
(31 recenzii)
3.8
balliesidhu

I'm glad to bid to this project. First tell me the complete information about your project I have faced and solved many similar issues so have good understanding about the task. Yes I can do this project for you becaus Mai multe

€30 EUR în 7 zile
(5 recenzii)
3.5
aramgev

Hello, I can help solving your task. I have 8 years experience with SQL and can easily solve your task

€10 EUR în 1 zi
(2 recenzii)
3.4
nidhi1509

Hi, I have 7+ Years of experience working in Top IT companies as a Database Developer using Oracle and MySQL databases. I expertise in writing complex Sql queries, procedures, functions, triggers, views etc. I have go Mai multe

€20 EUR în 1 zi
(7 recenzii)
3.1
deepthi2889

Hi, I am a Full stack developer in Microsoft technologies. My area of expertise is web application development (asp.Net web forms, MVC, classic ASP), web services (SOAP & RESTFul), MySql & Sql Server as back end (th Mai multe

€30 EUR în 1 zi
(3 recenzii)
3.5
gpnr2017

Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project using my expertise in sql queries. I have Over 12 years of experience in softwa Mai multe

€20 EUR în 1 zi
(4 recenzii)
2.2
giakcamp

Good afternoon, My name is Giacomo.I am a senior db administrator for MySQL and PostgreSQL. I will very happy to help you to fix your tables. Regards Giacomo Campanelli

€29 EUR în 2 zile
(4 recenzii)
1.5