如何在Mysql中将Top Value字段显示为top

Question

I want to show the college name and num of applications comes to each college and show most application received college as first position in MySQL query?

This is sample table, clg is college name and application_name column must be count() and highest value field must be show on top

My results must be like this....

Answer 1

try this,

SELECT `clg`,count(`clg`) AS clg 
FROM demo 
GROUP BY `clg` 
ORDER BY clg DESC