Q: Querying for duplicates with the same timestamp I am trying to fetch the duplicates from my prices `table that have the same timestamp. However, I am a bit stuck on how to approach thhis.
What I've got so far:
SELECT
COUNT(*) AS count,
article_id
FROM prices
GROUP BY article_id
HAVING count > 1;

This will produce a list with all duplicate prices, not concerned with whether or not the timestamp column differs.

A: Credits to my commenters and a thumbs down for me for not thinkng.
SELECT
COUNT(*) AS count,
article_id
FROM prices
GROUP BY article_id, price, tstamp
HAVING count > 1;

Adding price and tstamp to my GROUP BY clause did of course solve my problem.
