Skip to content

Instantly share code, notes, and snippets.

@zazk

zazk/select.all.rows.duplicates.values.sql

Last active November 10, 2017 19:29
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save zazk/52d724e15f28f03f1d34b6eeac7ff774 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save zazk/52d724e15f28f03f1d34b6eeac7ff774 to your computer and use it in GitHub Desktop.
Download ZIP
Select all Row Duplicates
Raw
select.all.rows.duplicates.values.sql
SELECT mto.id ,mto.latitud, mto.longitud
FROM talleres mto
WHERE EXISTS
(
SELECT 1
FROM talleres mti
WHERE mti.latitud = mto.latitud and mti.longitud = mto.longitud
LIMIT 1, 1
)
order by mto.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment