擅长:python、mysql、java
<p>我不认为这不可能没有:</p>
<ol>
<li>原始sql</li>
<li>用于检索按聚合结果筛选的对象的附加查询(这可能需要Q对象的帮助)</li>
</ol>
<p><strong>编辑1:</strong></p>
<p>关于2号溶液。这也许不是最好的主意,但这是我能想出的最快的办法:</p>
<pre><code>from django.db.models import Max, Q
from operator import __or__ as OR
result_dict = Score.objects.values('season').annotate(Max('punt'))
q = [Q(season=row['season']) & Q(punt=row['punt__max']) for row in result_dict]
qs = Score.objects.filter(reduce(OR, q))
</code></pre>
<p>查看此链接了解更多详细信息:
<a href="http://css.dzone.com/articles/best-way-or-list-django-orm-q" rel="nofollow">http://css.dzone.com/articles/best-way-or-list-django-orm-q</a></p>