Use this query:
SELECT
*,
count() AS cnt
FROM myDB.myTable
GROUP BY *
HAVING cnt > 1
ORDER BY date ASC
The GROUP BY clause groups the rows that have the same values in all columns (since * is used). This means that each unique combination of column values will form a group, and the count() function will count how many rows belong to each group.
After grouping, HAVING filters the results to include only those groups where the count (cnt) is greater than 1. This means that only groups with duplicate rows (i.e., where there are multiple identical entries) will be included in the final result set.