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

Revisions

monaxmp revised this gist Jun 18, 2018. No changes.

monaxmp created this gist Jun 4, 2018.

postgres find dublicat

-Original file line number
+Diff line change
@@ -0,0 +1,5 @@
+    select user_id, profession_id, count(*)
+    from professions
+    group by user_id, profession_id
+    HAVING count(*) > 1;