How to Use Alias in ORDER BY Caluse?

[Ji Zhang]

Hi,

My SQL is like "select host, count(*) as cnt from tbl group by host order by cnt desc"

How to achieve this using ORM?

session.query(Tbl.host, func.count('*').label('cnt')).group_by(Tbl.host).order_by(???)

I don't wanna type again func.count... in order_by().

Thanks.

[Michael Bayer]

count = func.count('*').label('cnt')

query(Tbl.host, count).group_by(Tbl.host).order_by(count.desc())

or

query(Tbl.host, func.count('*').label('cnt').group_by(Tbl.host).order_by(desc('cnt'))

[Ji Zhang]

The second one is neat. Thanks~