Loading

SQL query to Update A Column

Navaz

10y1.1k

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Navaz10y ago
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
0
Sujeet Suman10y ago
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.
0