cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marek Šabo <ms...@buk.cvut.cz>
Subject Order by count
Date Sun, 15 Aug 2010 12:28:55 GMT
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


Mime
View raw message