Re: [SQL] ORDER records based on parameters in IN clause

[Zac]

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org