Which is the max?

[dominant]

I have a field that holds the users id.

So now i want to keep some statistics and know who is the most active user.

So how could i determine number of the rows that the specific user involves and the userid with the maximum rows.

[steve8557]

Hi dominant,

use:
select count(user_id) from table group by user_id

HTH

Steve