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.

Remove last special character using jQuery

In this article I will show you how to remove the last special character from a string using JQuery. The input text jQuery event change slices the last char from the string with the help of slice property...