Django ORM 如何将一个表的查询结果作为新表进行查询操作？

This topic created in 1762 days ago, the information mentioned may be changed or developed.

SQL 写法：

SELECT MIN(max_salary),did
FROM
(SELECT MAX(salary) AS max_salary,e.`department_id`  did
        FROM employees e
        GROUP BY e.`department_id`)AS tmp

另外，SQLAlchemy 可以使用 alias()，请问 Django 如何实现这种写法？

3 replies • 2022-01-12 10:09:53 +08:00

yonng

Jan 12, 2022

https://docs.djangoproject.com/en/4.0/ref/models/expressions/#subquery-expressions

coolair

Jan 12, 2022

@yonng 文档已经看过，请问如何实现？谢谢。

IurNusRay

Jan 12, 2022

不是在后面接上 filter 就可以了吗
queryset1 = A.objects.filter()
queryset2 = queryset1.filter()