order by before group by in sqlalchemy-CodePudding

want to get last 2 name in my table for example

id    name    price
1     name1   100
2     name2   120
3     name3   100
4     name3   150
5     name3   152

i want result become

name
name3
name2

already searched similar questions here but find no answer in SQLalchemy

my try

orders = db.session.query(Table.name).filter(SomeFilter).order_by(Table.id.desc()).group_by(
        Table.name).all()

problem is group_by and order_by in same time have no issue with limit

CodePudding user response：

OK, I am (very) new to sqlalchemy (so do not mention the 'lot of' imports at the start of this code