Find Jobs
Hire Freelancers

Need Sql query for removing duplicates and fixing the relation table

€8-30 EUR

Avslutat
Publicerad nästan fem år sedan

€8-30 EUR

Betalning vid leverans
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
Project ID: 19741824

Om projektet

48 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
48 frilansar lägger i genomsnitt anbud på €25 EUR för detta uppdrag
Använd avatar
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 Om 1 dag
5,0 (246 omdömen)
7,6
7,6
Använd avatar
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 triggers. I have worked with several ERP databases to write queries and procedures to create custom reports. We will need a few SQL queries to get this done. We might need a tep table we can have all the duplicate ids in the form below id name replace_id 6 Tom 1 7 Lisa 3 8 Tom 1 Then use the above mapping to update the relationship table. Then finally remove the duplicates from the Names table. I can connect to your database on teamviewer and complete this. I can start immediately and finish today. Thanks Roni
€30 EUR Om 1 dag
5,0 (81 omdömen)
6,4
6,4
Använd avatar
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 Om 1 dag
5,0 (45 omdömen)
5,8
5,8
Använd avatar
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. Regards, Manish
€30 EUR Om 1 dag
4,9 (95 omdömen)
5,9
5,9
Använd avatar
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. Until this time, I have been working on development while considering credit as the best. If you hire me, I promise to give you the greatest service. If you want to conceive more ideas and make it happen, give me a chance. Go ahead and give me a chart.
€100 EUR Om 1 dag
5,0 (21 omdömen)
5,4
5,4
Använd avatar
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 best level for your project to run successfully. Looking forward to hearing from you.
€30 EUR Om 7 dagar
4,9 (36 omdömen)
5,3
5,3
Använd avatar
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 Om 1 dag
4,8 (20 omdömen)
5,1
5,1
Använd avatar
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. ***** We are highly qualified for this project and would love to speak with you further about taking this project on. I would like to introduce my company(Sapphire Software Solutions), We are 17 years old ISO Certified product and service based company and have worked on various projects. We have our own two products used by MNC companies worldwide. In .net technologies, we have 17 years of experience including ASP.NET C#, ASP.NET MVC, ASP.NET Core, ASP.NET AJAX, Web Services, Web API, Angular, AngularJS, TypeScript, Entity Framework, WebRTC, SignalR, MS SQL, Umbraco, DNN(Dot Net Nuke), etc. * able to code/solve any complex code in .net and to create/solve any complex SQL Query/SP. * Expert in Web Design(Bootstrap, CSS, HTML5, jQuery), Graphic design. * Hands on SVN, Git, VSS, TFS, BitBucket. We believe in providing services that are quick in terms of turnaround time and smart in terms of quality. Delays and low-quality work are kept at bay in our organization. Please Note: Quote is subject to change as per the final agreed scope. Thank you for taking the time to read my application. Best regards, Parth
€80 EUR Om 1 dag
5,0 (2 omdömen)
5,1
5,1
Använd avatar
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 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL BI - Microsoft MSBI and Informatica ETL Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... Cloud - Azure (Paas and IaaS) My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
€25 EUR Om 1 dag
5,0 (28 omdömen)
4,9
4,9
Använd avatar
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 result until you satisfy my working. You can contact me at any time. I am always ready for you. I 'll provide the best quality and exact timeline. I 'll do my best for your project. All that I developed for your project are yours. Please check kindly and feel free to contact me at any time. I'd be more happy to offer my service for you and am so excited to hear from you. Thanks and best regards. From Xun C.
€25 EUR Om 1 dag
4,5 (10 omdömen)
5,1
5,1
Använd avatar
Hi, I am interested in the task and have an experience in it. please ping me to discuss more. thanks
€9 EUR Om 1 dag
4,9 (30 omdömen)
4,5
4,5
Använd avatar
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 Om 1 dag
4,8 (17 omdömen)
4,5
4,5
Använd avatar
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 currently pursuing my Master's in Data Science from Trinity College Dublin. Thanks, Tousif
€30 EUR Om 0 dag
5,0 (12 omdömen)
4,3
4,3
Använd avatar
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 in database and I can also explain you the same. I am new here but I provide best results in short time. Please give me a chance to deliver my best services to you. 
€8 EUR Om 1 dag
4,7 (31 omdömen)
3,8
3,8
Använd avatar
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 because I have 7 years of Java experience We work mainly on JAVA-J2EE platforms. In JAVA-J2EE, we have experts of Spring, Spring Security, Spring Social, Struts2,Struts, Hibernate, JPA, Spring Micro-Services, Spring Boot, Spring Data JPA, java web service, velocity, freemarker, apache tiles ,apache ant, apache maven, Xml, Json, Jasper Report, Ireport ,android,Angular,Jquery,Vuejs java application server Tomcat, Glassfish, Jboss, Wildfly, Apache Axsis1 and Apache Axis2 Database: Mysql,Oracle,PostgreSql,Microsoft SqlServer,Hbase(Hadoop),MongoDB,Cassander IDE Netbean , Ecplise ,MyEcplise, Android Studio
€30 EUR Om 7 dagar
5,0 (5 omdömen)
3,5
3,5
Använd avatar
Hello, I can help solving your task. I have 8 years experience with SQL and can easily solve your task
€10 EUR Om 1 dag
5,0 (2 omdömen)
3,4
3,4
Använd avatar
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 gone through your project requirements and I can complete it as required within 2-3 hours. Let me know if you want me to work on it.
€20 EUR Om 1 dag
5,0 (7 omdömen)
3,1
3,1
Använd avatar
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 (through stored procedures). I have 7 years of experience as a full time software developer. Kindly contact me, lets discuss your requirements.
€30 EUR Om 1 dag
4,1 (3 omdömen)
3,5
3,5
Använd avatar
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 software development and support. On technical front I have good experience .net technologies, c#, Winforms, WPF, ASP .net MVC, MS SQL Server, MS Access, Excel VBA. I would very much enjoy having the opportunity to talk with you further to discuss the requirements and expectations regarding the project, and how I could use my skills to benefit you. Thank you for considering my application. I look forward to hearing from you. Regards, Naveen Upadhyay
€20 EUR Om 1 dag
5,0 (4 omdömen)
2,2
2,2
Använd avatar
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 Om 2 dagar
5,0 (4 omdömen)
1,5
1,5

Om kunden

Flagga för GERMANY
Heilbronn, Germany
5,0
12
Verifierad betalningsmetod
Medlem sedan jan. 30, 2014

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.