hi i tried first one
select top 100 cause i need only the 100 first people who have the most entry
so i did
select top 100 ID,
count (*)
from [database].
.
group by id
order by count (*);
i received an error
column [database].
.
is invalid in the select list because it is not contained
in either aggregate function or the group by clause
thanks for heping