You can

[4u]

I have a table that includes personid and songid;
how can i find out which song is popular,i mean just find out the popular songid.
I used "count(personid)",but result showed all the songid.
Thanks for help!!!

[SnoZ]

i'm not sure if u can do that, but maybe u gotta see the max() of the count(songid)...
sumthin' like(in ms access) pop:count(songid) and popular:max(pop).
hope i helped...