吞噬删除重复项(如果存在

original_list = [1, 2, 2, 3, 4, 4, 5]
unique_list = list(set(original_list))
print(unique_list)

original_list = [1, 2, 2, 3, 4, 4, 5]
unique_list = []
[unique_list.append(x) for x in original_list if x not in unique_list]
print(unique_list)

let originalArray = [1, 2, 2, 3, 4, 4, 5];
let uniqueArray = [...new Set(originalArray)];
console.log(uniqueArray);

let originalArray = [1, 2, 2, 3, 4, 4, 5];
let uniqueArray = originalArray.filter((value, index, self) => {
    return self.indexOf(value) === index;
});
console.log(uniqueArray);

-- 假设有一个名为my_table的表，其中有一个名为my_column的列
DELETE FROM my_table
WHERE id NOT IN (
    SELECT MIN(id)
    FROM my_table
    GROUP BY my_column
);