In VFP to find a dup for a certian key, I would:
SELECT key, count(*) as cnt ;
from table1 ;
group by key ;
having cnt > 1
In SQL Server how do I name the columns.
I need this for "HAVING" referencing. (If there's a better way - someone
clue me in PLZ!)