Need Sql query for removing duplicates and fixing the relation table

Zaprto Objavljeno pred 4 letoma/leti Plačilo ob prevzemu
Zaprto Plačilo ob prevzemu

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

Administracija podatkovnih baz Programiranje podatkovnih baz MySQL SQL

ID projekta: #19741824

Več o projektu

48 predlogov Oddaljen projekt Aktiven pred 4 letoma/leti

48 freelancerjev ponuja v povprečju za €25 na tem delu

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 v 1 dnevu
(246 ocen)
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 Več

€30 EUR v 1 dnevu
(81 ocen)
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 v 1 dnevu
(45 ocen)
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 Več

€30 EUR v 1 dnevu
(95 ocen)
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 Več

€100 EUR v 1 dnevu
(21 ocen)
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 Več

€30 EUR v 7 dneh
(36 ocen)
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 v 1 dnevu
(20 ocen)
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. ** Več

€80 EUR v 1 dnevu
(2 ocen)
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 Več

€25 EUR v 1 dnevu
(28 ocen)
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 Več

€25 EUR v 1 dnevu
(10 ocen)
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 v 1 dnevu
(30 ocen)
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 v 1 dnevu
(17 ocen)
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 Več

€30 EUR v 0 dneh
(12 ocen)
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 Več

€8 EUR v 1 dnevu
(31 ocen)
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 Več

€30 EUR v 7 dneh
(5 ocen)
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 v 1 dnevu
(2 ocen)
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 Več

€20 EUR v 1 dnevu
(7 ocen)
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 Več

€30 EUR v 1 dnevu
(3 ocen)
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 Več

€20 EUR v 1 dnevu
(4 ocen)
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 v 2 dneh
(4 ocen)
1.5