Re: ORDER records based on parameters in IN clause - Mailing list pgsql-sql

> SELECT
>     table.*
> FROM
>     table
>     JOIN (SELECT id, count(id) AS count FROM... your subquery) AS x
> ORDER BY
>     x.count
> 
> Bye.
Sorry: I forgot join condition:
SELECT    table.*
FROM    table    JOIN (SELECT id, count(id) AS count FROM... your subquery) AS x ON 
(table.id = x.id)
ORDER BY    x.count