Top Solutions

How to delete duplicate rows in sql?

Here I am using CTE(Common Table Expression) for Delete duplicate rows. PARTITION BY : It devides the query result into partitions Row_NUMBER : gives unique name for all duplicate rows ie., if one row record repeated for 3 times . it gives the index such as 1,2 and 3 Using this query we can delete all duplicate rows in a table

How to remove last special character using C#?

Remove last special character if last character is question mark. First we have to check the last character in given string is question mark or not. If last character is question mark then we remove the last character.