SQL query to Update A Column

Question

Sql query For Update A Column In a table With a Condtion Of Same Table value in the image Last output attendence Column repeat in Same day for a same saleman Id

Navaz · Answer

Sir Actually Idont want To Delete Dulplicate Rows I need to Remove Only A perticluar Row based on a condition that Date Repetaion for a same salesman

Sujeet Suman · Answer

Navaz please make ( salemanId + attendence) as primary key or you can say composite key. So that will not allow to enter duplicate record in table while updating. If this is helpful for you then please accept my Answer .