monaxmp/postgres find dublicat

Last active June 18, 2018 15:50

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

Select an option

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

Download ZIP

postgres find dublicat

Raw

postgres find dublicat


	select user_id, profession_id, count(*)
	from professions
	group by user_id, profession_id
	HAVING count(*) > 1;

Author

monaxmp commented Jun 18, 2018

postgres find dublicat

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