mysql how to organize by the no. of rows?

[ted_chou12]

I want to organize according to the number of entries, every row has a column value called threadid, which may repeat for different rows, so I wish to put the most frequent appearing threadid on the top, and least at the bottom, is this suppose to be done with GROUP? or something else?

Thank you

Ted

[CrazeD]

If I understand what you're trying to do, you would put:

 

ORDER BY threadid DESC

 

into your query.

 

You can change DESC to ASC (descending or ascending).

[ted_chou12]

sorry, I didnt explain clearly enough, I wish to organize the rows by the frequency of the appearance, for example:

id threadid

1 2

2 3

3 1

4 2

5 4

 

so I want the order to look like:

2 (2 comes first because it occured the most frequent.)

3

1

4

the rest would automatically organize by id, since they have the same frequency.

Ted

Hope that makes it clear

 

[sasa]

try

SELECT *  FROM `table` 
ORDER BY (SELECT COUNT(`id`) FROM `table` a WHERE a.threadid=table.threadid) DESC

[ted_chou12]

thanks

[ted_chou12]

sorry, I have a question, what does a stand for please?