selecting unique values from a column October 18, 2022 by Tarik Use the DISTINCT operator in MySQL: SELECT DISTINCT(Date) AS Date FROM buy ORDER BY Date DESC;