请教下 Flask-Sqlalchemy 查询最大值是怎么写？ Sqlalchemy 是 func.max FlaskSqlalchemy 没有看到相关的语法。
推荐学习书目
› Learn Python the Hard Way
Python Sites
› PyPI - Python Package Index
› http://diveintopython.org/toc/index.html
› Pocoo
值得关注的项目
› PyPy
› Celery
› Jinja2
› Read the Docs
› gevent
› pyenv
› virtualenv
› Stackless Python
› Beautiful Soup
› 结巴中文分词
› Green Unicorn
› Sentry
› Shovel
› Pyflakes
› pytest
Python 编程
› pep8 Checker
Styles
› PEP 8
› Google Python Style Guide
› Code Style from The Hitchhiker's Guide
This topic created in 2878 days ago, the information mentioned may be changed or developed.
4 replies • 2018-12-25 11:09:10 +08:00
 |
autotestingDec 24, 2018
1
groupby 后才能用 func.max, func.min 这样
|
 |
2
@autotesting 有参考的例子吗，，现在我的方法是执行原始 sql 语句
|
|
autotestingDec 24, 2018
3
其实很多，https://stackoverflow.com/questions/45775724/sqlalchemy-group-by-and-return-max-date
你搜关键词 sqlachemy groupby func.max |
|
4
@autotesting 我用这样的语法查出来为空
userbalance_model.query.filter_by(user_id = parse.user_id, asset = parse.coin).with_entities(func.max(userbalance_model.id)).all() |
Select Language