[Solved] SQL statement thinking non distinct [closed]

by


A simple GROUP BY should work for you:

SELECT Col1,Col2
FROM YourTable T
GROUP BY Col1,Col2
HAVING COUNT(*) > 1

Please post what you have tried going forward…

–EDIT–

If you’re look at returning all rows that have the same lat/lon, then something like this would work:

SELECT *
FROM YourTable
WHERE (lat,lon) IN (
      SELECT lat,lon
      FROM YourTable
      GROUP BY lat,lon
      HAVING COUNT(*) > 1
)

http://sqlfiddle.com/#!2/f9658/5

7

solved SQL statement thinking non distinct [closed]