What does the DISTINCT keyword do in a MariaDB SELECT query?
a) It removes duplicate rows from the result set
b) It sorts the result set
c) It calculates averages for each column
d) It limits the number of rows returned
Answer:
a) It removes duplicate rows from the result set
Explanation:
The DISTINCT keyword is used in a SELECT query to ensure that duplicate rows are removed from the result set.