Is there a way to count duplicates (cnt), and in the same run limit the output to only instances where cnt>1?
ROW_NUMBER() OVER(PARTITION BY NText ORDER BY NText) AS CNT
WHERE NText IS NOT NULL
In this example, since the CNT is in SELECT I can't use it to cull in the WHERE. This example is the gist fo what I'm trying to do, how can I order this statement better?