Skip to content

Instantly share code, notes, and snippets.

@ManiruzzamanAkash

ManiruzzamanAkash/Opening Stock Entry which has entered more than once in a second.sql

Last active October 29, 2019 08:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ManiruzzamanAkash/8c712cb08821d8b8a99c82b788f43d83 to your computer and use it in GitHub Desktop.
Save ManiruzzamanAkash/8c712cb08821d8b8a99c82b788f43d83 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Opening Stock Entry which has entered more than once in a second.sql
SELECT created_at, COUNT(created_at)
FROM `transactions`
WHERE type='opening_stock'
GROUP BY created_at
HAVING COUNT(created_at) > 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment