[SOLVED] Syntax error?

[Azu]

Hello.. can somebody please tell me why this is giving me a syntax error and how to fix it?

 

select * from table group by row order by count(group(row))

[trq]

Because it is syntactly incorrect. COUNT returns a number, do you have a filed named with that number?

[Azu]

Okay I have a table like this

 

 

ID    UserID    Stuff

 

1        3          Blah

2        5          Blah

3        1          Blah

4        3          Blah

5        9          Blah

6        20          Blah

7        3          Blah

8        15          Blah

9        5          Blah

etc

 

 

And I want the query to return this

 

3,3

5,2

(the rest),1

 

But I can't get it to work :s

[svivian]

I think you just need count(row) rather than count(group(row)) but I'm not sure.

 

Can you explain in more detail how you want that output (3,3 / 5,2), where you're getting those number from? Do you want to obtain the number of times each UserID is used?

[fenway]

Sounds like you want:

 

SELECT
UserID, COUNT(ID)
FROM yourTable
GROUP BY  UserID

[Azu]

Thanks guys! ^^