Does anyone have an idea how to run this query...
without the sub query?Code:
WHERE [ColumnName] IN
GROUP BY [ColumnName]
HAVING COUNT(*) > 1
ORDER BY [ColumnName]
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.