DISTINCT in MySQL

MySQL DISTINCT In MySQL, the DISTINCT clause is used with the SELECT statement to retrieve the unique records from the result set.

Syntax:

SELECT DISTINCT expressions  
FROM tables  
WHERE conditions;

Parameters:

expressions: It is used to specify the columns to be selected. table_name: It is used to specify the name of the table from which the data needs to be retrieved. conditions: It is used to specify the conditions to be strictly fulfilled for the selection.

Example 1: Using Distinct Select for a single column. Items table:

ID	NAME	QUANTITY
1	Electronics	30
2	Sports	45
3	Fashion	50
4	Grocery	30
5	Toys	50

 

Distinct Select Query:

SELECT DISTINCT quantity  
FROM items;

Output:

QUANTITY
30
45
50

Explanation:

The ‘items’ is an already existing table from which we are fetching the unique quantity of the items.

Example 2: Using Distinct Select for multiple columns. Items table:

ID	NAME	QUANTITY
1	Electronics	30
2	Sports	45
3	Fashion	50
4	Grocery	30
5	Toys	50

 

Distinct Select Query:

SELECT DISTINCT name, quantity
FROM items;

Output:

NAME	QUANTITY
Electronics	30
Sports	45
Fashion	50
Grocery	30
Toys	50

Explanation: The ‘items’ is an already existing table from which we are fetching the unique name and quantity of the items.