SQLAlchemy的group_by和order_by的区别
2024-09-30 05:30:14
- 1、官网解释:
group_by
(*criterion)-
apply one or more GROUP BY criterion to the query and return the newly resulting
Query
2、官网解释:
order_by
(*criterion)
apply one or more ORDER BY criterion to the query and return the newly resulting Query
All existing ORDER BY settings can be suppressed by passing None
- this will suppress any ORDER BY configured on mappers as well.
Alternatively, an existing ORDER BY setting on the Query object can be entirely cancelled by passing False
as the value - use this before calling methods where an ORDER BY is invalid.
参考:
1、http://docs.sqlalchemy.org/en/rel_0_9/orm/query.html
2、http://www.w3school.com.cn/sql/sql_groupby.asp
最新文章
- Operation not allowed after ResultSet closed--操作mysql数据库
- 使用 pod install 还是 pod update ?
- 用redux构建购物车
- 【BZOJ-1552&;3506】robotic sort&;排序机械臂 Splay
- String to Integer
- java使用Cipher进行签名和验签
- 了解CentOS及周边
- CSS强制英文换行
- phpcms 模板常用标签指南
- redhat7 常用命令
- 我们一起学Docker(一)
- JAVA入门[21]-Jedis操作redis示例
- Definition of matrix norms
- git rebase的用法
- Servlet随笔
- plsql 工具怎样导出 oracle 表数据
- .NET Core 2.0 单元测试中初识 IOptionsMonitor<;T>;
- mysql--SQL编程(关于mysql中的日期,关于重叠) 学习笔记2.2
- python 等比数列
- 集合List与DataTable互转