I have a table of tags and want to get the highest count tags from the list.

Sample data looks like this

    id (1) tag (&#39;night&#39;)
    id (2) tag (&#39;awesome&#39;)
    id (3) tag (&#39;night&#39;)

using

    SELECT COUNT(*), `Tag` from `images-tags`
    GROUP BY `Tag`

gets me back the data I&#39;m looking for perfectly. However, I would like to organize it, so that the highest tag counts are first, and limit it to only send me the first 20 or so.

I tried this...

    SELECT COUNT(id), `Tag` from `images-tags`
    GROUP BY `Tag`
    ORDER BY COUNT(id) DESC
    LIMIT 20

and I keep getting an &quot;Invalid use of group function - ErrNr 1111&quot;

What am I doing wrong?

I&#39;m using MySQL 4.1.25-Debian

SQL Group By with an Order By

I am using MySQL. Here is my schema:

Suppliers(**sid: integer**, sname: string, address string)

Parts(**pid: integer**, pname: string, color: string)

Catalog(**sid: integer, pid: integer**, cost: real)

(primary keys are bolded)

I am trying to write a query to select all parts that are made by at least two suppliers:

    -- Find the pids of parts supplied by at least two different suppliers.
    SELECT c1.pid                      -- select the pid
    FROM Catalog AS c1                 -- from the Catalog table
    WHERE c1.pid IN (                  -- where that pid is in the set:
	    SELECT c2.pid                  -- of pids
	    FROM Catalog AS c2             -- from catalog
	    WHERE c2.pid = c1.pid AND COUNT(c2.sid) &gt;= 2 -- where there are at least two corresponding sids
    );

First off, am I even going about this the right way?

Secondly, I get this error: 

&gt; 1111 - Invalid use of group function

What am I doing wrong?

All Mysql Error-1111 Solutions on Gang of Coders

Total of 2 Mysql Error-1111 Solutions

SQL Group By with an Order By

MySQL: Invalid use of group function