i still have the same error message
this is what i wrote:
select top 100 id, personid,name, firstname,
count (*) mycount
from [database].
.
group by id, personid,name, firstname
order by mycount;
and i have the same error saying:
column is invalid.....