The following SQL query can be used to obtain unique or different values for a column in MySQL Table. There are different values that can be assigned to one or more columns. You must separate the column names with a comma.

Syntax

SELECT DISTINCT(column_name) FROM your_table_name;

Example

SELECT DISTINCT(email) FROM Employee;

BY Best Interview Question ON 21 Sep 2022