MariaDB DISTINCT
The MariaDB DISTINCT clause is used with the SELECT statement to eliminate the duplicate records from the result set.
Syntax:
SELECT DISTINCT columns FROM tables WHERE conditions;
Parameters:
conditions: It is used to specify the conditions to be strictly fulfilled for the selection.
Example 1: Using Distinct Select for single column.
Players table:
ID NAME SPORTS 1 Sachin Cricket 2 Dhoni Cricket 3 Sunil Football 4 Srikanth Badminton 5 Mary Boxing
Distinct Select Query:
SELECT DISTINCT sports FROM Players WHERE sports = ‘Cricket’; |
Output:
SPORTS Cricket
Explanation:
The ‘Players’ is an already existing table, from which we are retrieving the unique value where SPORTS = ‘Cricket’ from the SPORTS column.
Example 2: Using Distinct Select for multiple columns.
Players table:
ID NAME SPORTS 1 Sachin Cricket 2 Dhoni Cricket 3 Sunil Football 4 Srikanth Badminton 5 Srikanth Badminton
Distinct Select Query:
SELECT DISTINCT name, sports FROM Players WHERE id > 2; |
Output:
NAME SPORTS Sunil Football Srikanth Badminton
Explanation:
The ‘Players’ is an already existing table, from which we are retrieving the unique values from the NAME and SPORTS column where ID is greater than 2.