SQL - 如何选择具有相同ID的多行的第一行(或任何唯一行)？

SELECT *
FROM table_name
WHERE id IN (SELECT id FROM table_name GROUP BY id HAVING COUNT(id) = 1);

SELECT t1.*
FROM table_name t1
INNER JOIN table_name t2 ON t1.id = t2.id
WHERE t2.id IS NULL;

SELECT *
FROM table_name
WHERE id = (SELECT id FROM table_name WHERE id = table_name.id)
AND NOT EXISTS (SELECT 1 FROM table_name WHERE id = table_name.id);