SELECT DISTINCT column_name1, column_name2 FROM table_name;
DISTINCT clause in MYSQL is used to get record which are not duplicate to others. You can find distinct records from a table in MySQL using DISTINCT clause.
If there is a table named students which has two columns named first_name and last_name and there are some records which has duplicate entry in first_name column.
If you want to get all the records where first_name column records are not same then run below query
SELECT DISTINCT first_name FROM students;
To get distinct records by first_name and last_name combination run below.
SELECT DISTINCT first_name, last_name FROM students;