原则DQL每组最大n

本文介绍了原则DQL每组最大n的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

这是我的Symfony2项目的2个表：

Here are 2 tables of my Symfony2 project :

+-----------+     +----------------------------+ 
|  EVENT    |     |         PHOTO              |
+-----------+     +------+-----------+---------+
|    id     |     | id   | event_id  |  likes  |
+-----------+     +------+-----------+---------+
|     1     |     |  1   |    1      |   90    |
|     2     |     |  2   |    1      |   50    |
+-----------+     |  3   |    2      |   20    |
                  |  4   |    2      |   10    |
                  +------+-----------+---------+

我想选择2个最喜欢的照片，它看起来像是：

I would like to select the 2 events with its most liked photo, which would look like :

+------------+------------+---------+  
|  event_id  |  photo_id  |  likes  |  
+------------+------------+---------+
|     1      |     1      |    90   |
+------------+----------------------+
|     2      |     3      |    20   |
+------------+----------------------+

此处介绍了SQL解决方案（（如果答案无效）按预期

Here's a link to the documentation: Native Query, if the answer is not working as intended

这篇关于原则DQL每组最大n的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！