MariaDB DISTINCT Clause is used to remove duplicates from the result when it is used with SELECT statement.

Syntax:

SELECT DISTINCT expressions

FROM tables

[WHERE conditions];