It may happen times to times you need to delete duplicate rows from a table. There are many options to do that. I will write on my blog one of my option that I am using often to remove duplicate rows from a table.
Let’s say we have a…readmore →
Many time I had problem to update or delete rows from one table depends from another table (inner join). Like we make select from two or more tables with inner join in the same way we can make also update or delete.
Let’s take an example where we have…readmore →