Skip to content

Instantly share code, notes, and snippets.

@smetronic

smetronic/data.sql

Created November 14, 2018 18:12
Show Gist options
  • Save smetronic/c3017ed6757616a1a961b3a5ad4f048f to your computer and use it in GitHub Desktop.
Save smetronic/c3017ed6757616a1a961b3a5ad4f048f to your computer and use it in GitHub Desktop.
Download ZIP
List of duplicates rows
Raw
data.sql
SELECT
UID, COUNT(Timestamp), Timestamp, GROUP_CONCAT(id)
FROM
Transactions
GROUP BY
UID,Timestamp
HAVING
COUNT(Timestamp) > 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment