在SQLAlchemy中使用distinct后更改order_by

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

# 创建数据库连接
engine = create_engine('数据库连接字符串')

# 创建会话
Session = sessionmaker(bind=engine)
session = Session()

# 定义模型
Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    age = Column(Integer)

# 查询去重后按照age字段降序排序的结果
query = session.query(User.age).distinct().order_by(User.age.desc())

# 执行查询
result = query.all()

# 输出结果
for row in result:
    print(row.age)