DISTINCT Clauses - (MariaDB Clauses)

In MariaDB, the DISTINCT keyword is used to ensure that the result set of a query contains only unique values. It is often used in conjunction with the SELECT statement.

Syntax

SELECT DISTINCT column1, column2, ...
FROM table_name
WHERE condition;

Here, DISTINCT is the keyword used to specify that only unique values in the results should be returned. column1, column2, etc. are the columns that are being selected from the table. table_name is the name of the table being queried, and condition is an optional condition to filter the results.

Example

Here is an example of using the DISTINCT keyword in a MariaDB query:

SELECT DISTINCT category
FROM products
WHERE price > 10;

This query selects all unique values in the category column of the products table where the price is greater than 10.

Output

The output of the query will be a list of unique values in the category column of the products table where the price is greater than 10.

Explanation

In the above example, we are using the SELECT statement to select the category column from the products table. We are then using the DISTINCT keyword to ensure that only unique values are returned. Finally, we are using the WHERE clause to filter the results based on the price column.

Use

The DISTINCT keyword is useful in queries where we want to remove duplicate values from the result set. When working with large datasets, it can be helpful to only select unique values to reduce the amount of data being returned.

Important Points

• The DISTINCT keyword is used to ensure that only unique values are returned in a MariaDB query.
• It is often used in conjunction with the SELECT statement to remove duplicate values from the result set.
• The WHERE clause can be used to filter the results based on certain conditions.

Summary

In summary, the DISTINCT keyword is a powerful tool in MariaDB that allows us to remove duplicate values from the result set of a query. It is often used in combination with the SELECT statement to reduce the amount of data being returned, especially when working with large datasets.