Does anyone have an idea how to run this query...
WHERE [ColumnName] IN
GROUP BY [ColumnName]
HAVING COUNT(*) > 1
ORDER BY [ColumnName]
without the sub query?
The sub query option seems to be taking ages to run. Is there a more efficient query that does the same thing?
Thanks in advance for any help.