SELECT prob

[drisate]

hey guys, how can i select the username that has appeared the most in a colum?

 

SELECT attname FROM war order by count(id) desc limit 1

 

Thats not working

[The Little Guy]

Something like this:

 

SELECT COUNT(attname) FROM war GROUP BY attname

[drisate]

hmmm nope and this si not working to

 

SELECT COUNT(attname) as num FROM war GROUP BY attname order by num

[The Little Guy]

Try it like this:

 

SELECT COUNT(id) as num FROM war GROUP BY attname DESC

 

If that doesn't work, please explain what the result is doing.

[drisate]

nope that outputs a number. i need it to output the value of attname

The number is not even good thought

[The Little Guy]

could you give me an example output that you want?

[premiso]

SELECT attname, count(id) as num FROM war GROUP BY attname

 

Should do it, given that the primary key field is "id"