Get Duplicate row from particular column in single mysql query

by Subramanian 2014-09-05 14:17:59

Get Duplicate row from particular column in single mysql query

SELECT calculator.urlpath FROM calculator
INNER JOIN (SELECT urlpath FROM calculator
GROUP BY urlpath HAVING count(id) > 1) dup ON calculator.urlpath = dup.urlpath and calculator.urlpath!=""
571
like
0
dislike
0
mail
flag

You must LOGIN to add comments