Re: [SQL] COUNT(*) to find records which have a certain number of

[Rod Taylor]

On Mon, 2004-09-20 at 12:19, T E Schmitz wrote:
> I figured it eventually. (The only thing I don't know is where to put
> the ORDER BY.)

Try this:
        
        SELECT brand_name, model_name
          FROM (SELECT ... INTERSECT SELECT ...) AS t
        ORDER BY ...


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings