SQL DISTINCT用法详解：快速去除重复数据的完整指南

SELECT DISTINCT column_name FROM table_name;

SELECT DISTINCT book_title, author_name FROM library_books;

-- 使用 DISTINCT SELECT DISTINCT department, job_title FROM employees;

-- 使用 GROUP BY
SELECT department, job_title FROM employees GROUP BY department, job_title;