how can i write this query |
for one machting filed you can us this statement
Code: delete r1 It deletes all duplicate rows based on the field 'duplicate' and leaving the row with the lowest id. Test it before you use it in production ![]() If you need more matches look at this usefull post: http://stackoverflow.com/questions/25948...-sql-table |
Messages In This Thread |
how can i write this query - by rajneeshgobin - 11-04-2014, 10:42 PM
RE: how can i write this query - by Jeroen - 11-05-2014, 05:17 AM
RE: how can i write this query - by Rufnex - 11-05-2014, 07:54 AM
|