Hi, I could use some help for an SQL query to remove duplicates
| Id | lotid | description | price
a. 1 | 12 | xxx | 45
b. 2 | 24 | aaa | 75
c. 3 | 12 | xxx | 46
d. 4 | 12 | xx | 55
I am looking for a query that would find the duplicates based on |lotid| and then keep 1 random (a or c or d) and remove the others so we only have 1 unique lotid.
Dear Sir, I have experience with database management and can help you with this task. If you need a script in PHP or a C# program to run this task multiple times, I can also help. Thank you for considering my propos Plus
53 freelances font une offre moyenne de 19 $ pour ce travail
Hello, As an expert in SQL, I can write the required DELETE query for your scenario. Looking forward to have a positive response from you. Thanks
I have good knowledge of PHP, Ajax, Jquery and MYSQL also Payment gateway. I able to do this task very well with good quality. My main motto is client satisfaction and makes a long-term relationship with you. I’m read Plus
hello i can do this work give me replay so we chat more i can do this max 2 hours i have 8 years experience in this field thanks
Hello sir! I am ready to build the SQL query for you which will remove duplicate as you have mentioned. Lets talk and do it. Thanks!
Hi, i can write this query for removing duplicate rows basis on lotid column. Please ping me thanks Ravinder Singh
Done. Hi, I have the needed query, please chat with me to give you the query. I have experience in VB.net, MS SQL server, asp.net and crystal reports more than 13 years. Other skills: Access vba, Excel vba, C#, my Plus
-- 20 years SQL Query Expert ------ easily can solve your task , I check it already ------------- we can discuss to start
I can develop required SQL Update statement to remove duplicates because I am highly qualified SQL developer with a long term professional experience.
Hello Sir! I am sql expert. Give us opportunity to write this simple query to fetch only unique items base on your required id. Please discuss further through message. Thanks.
Hi! When viewing your job details, it really jumped out at me. In my current Professional Microsoft SQL Server DBA role, I have extensive experience with Develop T-SQL queries to remove Duplicate records keeping with U Plus
Hi I'm a French web developer with very good SQL skills (my first job was DBA) I can create the complete query in order to remove all duplicates except one based on lotid Job can be done within 2 days Regards Akex
Hi there I am doing Software Engineering ,Having 2 years experience especially in programming (i.e. Java,C#,C++,C,Python), Data Preprocessing, Code Debugging, Database connections, App development and much more. I can Plus
Hi Sir, I have done same kind of work previously, I will solve your problem after your satisfaction release the payment
Hi there! I would like to work with you on this project. I can confidently help you with your duplicate rows deletion task using SQL Query. I'm SQL Server Performance/Emergency Expert; with 5 years of professional ex Plus
*** Certified C# programmer *** I am a experienced .net developer. I have read your project details.I have worked on several similar projects. My Top Skills are C#, ASP.Net, ASP.Net MVC, CSS, HTML, Bootstrap, APIs, Js Plus
hello, you can achieve the required result using DISTINCT sql operation, i can help you in this query and more, contact me for more details best regards