Viewing 2 posts - 1 through 2 (of 2 total)
[font="Courier New"]select top 10 user,count(activity) 'Activity_Count'
from tablename
group by user
order by count(activity) desc[/font]
October 9, 2010 at 3:19 am
#1234602
hi
does some one know?
thanks
October 8, 2010 at 10:45 am
#1234385