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