nikolasd/find_duplicate_reservations.sql

Last active October 23, 2018 13:37

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/nikolasd/c45f94ec7553e62c551ba6746af24588.js"></script>
Save nikolasd/c45f94ec7553e62c551ba6746af24588 to your computer and use it in GitHub Desktop.

Download ZIP

Pylon SQL - Εύρεση διπλών reservations

Raw

find_duplicate_reservations.sql

	SELECT
	heresnum,
	COUNT(*)
	FROM HERESERVATIONS
	GROUP BY heresnum
	HAVING COUNT(*) > 1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment