i have table
roll no name serial
1 name1 123
1 name2 121
1 name3 120
1 name4 124
2 name 125
this table have duplicate recorcd in rollno field but my doubt how to be remove the duplicate record except first row please tell me sql command?
Results 1 to 4 of 4
Thread: remove duplicate recordThreaded View
|
Click Here to Expand Forum to Full Width |