Order by count

From: Marek Šab (msab..uk.cvut.cz)
Date: Sun Aug 15 2010 - 12:28:55 UTC

  • Next message: Andrus Adamchik: "Re: Order by count"

    Hi,

    I'm not sure but is there support in Cayenne EJBQL impl. for ordering by
    aggregate functions? (I think JPQL spec. has it)

    I'm getting syntax error on these:

    SELECT p.account, count(p) FROM PortJump p GROUP BY p.account, ORDER by
    count(p) DESC

    SELECT p.account, count(p) AS cnt FROM PortJump p GROUP BY p.account
    ORDER BY cnt DESC

    Thanks for information, regards 

    -- 
Marek Šabo

    This archive was generated by hypermail 2.0.0 : Sun Aug 15 2010 - 12:29:35 UTC