ORDEY BY ... Count

[DrZoidberg]

Hi, is there anyway to perform a query and have it order by the count? I thought it was possible but keep getting an error. I'm using the following:

SELECT st_term, COUNT(st_term) AS QueryCount FROM tblSearchTerms GROUP BY st_term ORDER BY QueryCount

Any help would be *hugely* appreciated.

Many thanks.

 

[namliam]

include the count statement not the alias...

 

[DrZoidberg]

great, thanks!!