t-sql find top 10 users in tabel

• xxx_olduser_9999

  Newbie

  Points: 9

  More actions

  October 9, 2010 at 2:08 am

  #97598

  hi guys,

  I'm new to this forum so I hope I'm posting in the right forum.

  question is:

  I have a table which holds activities from users.

  1 activity = 1 record.

  I want the the top 10 users with the most activities.

  I'm kinda new to this whole sql thing, so I can't really figure it out.

  can someone help here? thanks a bunch!

• qaz123 90964

  SSC Enthusiast

  Points: 157

  More actions

  October 9, 2010 at 3:19 am

  #1234602

  [font="Courier New"]select top 10 user,count(activity) 'Activity_Count'

  from tablename

  group by user

  order by count(activity) desc[/font]