Get Duplicate row from particular column in single mysql query
by Subramanian[ Edit ] 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!=""