N
SELECT [CaseNumber], COUNT(*) AS Occurrences
FROM [CaseCountry]
GROUP BY [CaseNumber]
HAVING (COUNT(*) > 1)
N
DELETE FROM FriendsData WHERE fID
NOT IN ( SELECT fID FROM FriendsData
GROUP BY UserID, FriendsUserID, IsSpecial, CreatedBy)
N
UPDATE tableName SET columnName = yourValue;
#to update multiple columns:
UPDATE tableName SET column1 = value1, column2 = value2; #and so on
N
DELETE c1 FROM contacts c1
INNER JOIN contacts c2
WHERE
c1.id > c2.id AND
c1.email = c2.email;
N
DELETE FROM NAMES
WHERE id NOT IN (SELECT *
FROM (SELECT MIN(n.id)
FROM NAMES n
GROUP BY n.name) x)
N
DELETE FROM table_name
WHERE
id IN (
SELECT
id
FROM (
SELECT
id,
ROW_NUMBER() OVER (
PARTITION BY field_1
ORDER BY field_1) AS row_num
FROM
table_name
) t
WHERE row_num > 1
);