Simple sql querry

Hi, I could use some help for an SQL query to remove duplicates

Table: items

| Id | lotid | description | price

example data

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.

Compétences : SQL, Serveur SQL Microsoft, MySQL, Programmation C#, PHP

en voir plus : bangladesh based looking service ongoing data entry work, sql statement update employee salary based hire date, quickbooks import items sql server, non moving stock items sql, sql server front end web based, example job description commission based sales, add items sql database blackthorne ebay, description school management java sql, android menu items sql, display number customers purchased items sql, simple quiz android source code random questions, simple net restful data access example, sql table remove, i am looking for remote desktop support techs to handle virus removal diagnosis optimization data back up, i am looking for a designer for a small bedroom for 2 boys in nz, sql server compact 3.5 service pack 2, Hi everyone, We\ re looking for a logo representing a capsule for Nespresso Machines, with our name : \ n\ Hot de sens\ ., sql server pivot multiple columns based on one column, sql azure is a cloud-based relational database service that is based on mysql

Concernant l'employeur :
( 31 commentaires ) Brussel, Belgium

Nº du projet : #28767368

Décerné à:


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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(18 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(377 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(165 Commentaires)
(94 Commentaires)
(103 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(196 Commentaires)

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!

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(203 Commentaires)

Hi, i can write this query for removing duplicate rows basis on lotid column. Please ping me thanks Ravinder Singh

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(237 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(21 Commentaires)

-- 20 years SQL Query Expert ------ easily can solve your task , I check it already ------------- we can discuss to start

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(46 Commentaires)

I can develop required SQL Update statement to remove duplicates because I am highly qualified SQL developer with a long term professional experience.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(46 Commentaires)

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(51 Commentaires)

use group by lotid and create new view which filter lotid

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(30 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(18 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(18 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(45 Commentaires)

Hi Sir, I have done same kind of work previously, I will solve your problem after your satisfaction release the payment

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(35 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(17 Commentaires)

Hi there, I will be happy to help you on your project as i have 4 years experience in: • api, .net , c# , c++ , java. • JavaScript , HTML , CSS , jquery , bootstrap. • angular , react. • nodejs , mongodb. This projec Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(9 Commentaires)

*** 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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(17 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(15 Commentaires)