blocks|key|4643302|text|问题：https://github.com/sequelize/sequelize/issues/348|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4643303|User.findAll({
+group:+['field']
})|code-block|syntax|javascript|4643304|我使用sequelize@2.0.0-dev9|4643305|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/sequelize/sequelize/issues/348^0|3|1D|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|C|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

issue: <a href="https://github.com/sequelize/sequelize/issues/348">https://github.com/sequelize/sequelize/issues/348</a>

<pre><code>User.findAll({
 group: ['field']
})
</code></pre>

i use sequelize@2.0.0-dev9

blocks|key|136737|text|Group+by计数为sequelize+ORM|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|136738|'field'+-自定义用户输入，您可以重命名此字符串，它是数据库中的field(column)|136739|'count'+-在sequelize中get+count需要保留的序列化关键字字符串|136740|'cnt'+-自定义用户输入，您可以重命名此字符串，它是您的输出count|136741|序列化版本3.25.0|136742|User.findAll({
++++++attributes:+['field',+[sequelize.fn('count',+sequelize.col('field')),+'cnt']],
++++++group:+['field'],
})|code-block|syntax|javascript|136743|entityMap^0|B|D|0|0|7|Z|D|0|0|7|A|9|O|5|0|0|5|W|5|0|5|6|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@$9|Y|A|Z|B|C]|$9|10|A|11|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|12|8|@$9|13|A|14|B|C]|$9|15|A|16|B|C]|$9|17|A|18|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|19|8|@$9|1A|A|1B|B|C]|$9|1C|A|1D|B|C]]|D|@]|E|$]]|$1|L|3|M|5|6|7|1E|8|@$9|1F|A|1G|B|C]]|D|@]|E|$]]|$1|N|3|O|5|P|7|1H|8|@]|D|@]|E|$Q|R]]|$1|S|3|-4|5|6|7|1I|8|@]|D|@]|E|$]]]|T|$]]

Group by with count <code>sequelize ORM</code>
<code>'field'</code> - custom user input, you can rename this string, it's your <code>field(column)</code> in database
<code>'count'</code> - reserved sequelize keyword string need for get <code>count</code> in <code>sequelize</code>
<code>'cnt'</code> - custom user input, you can rename this string, it's your output <code>count</code>
Sequelize version <code>3.25.0</code>
<pre><code>User.findAll({
 attributes: ['field', [sequelize.fn('count', sequelize.col('field')), 'cnt']],
 group: ['field'],
})
</code></pre>

blocks|key|4643364|text|试试这个-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4643365|Table.count(
{
+++attributes:+['column'],+
+++group:+'column',
}+|code-block|syntax|javascript|4643366|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this -

<pre><code>Table.count(
{
 attributes: ['column'], 
 group: 'column',
} 
</code></pre>

blocks|key|4643328|text|示例:如何在分组函数列中添加方便的别名。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4643329|我把这个作为一个单独的回复，主要是因为它在评论中不会有很好的格式...否则，我会将其添加到Sampat的答案中。|4643330|function+getSumsBySomeId()+{
++const+criteria+=+{
++++attributes:+['some_id',+[sequelize.fn('sum',+sequelize.col('some_count')),+'some_count_sum']],
++++group:+['some_id'],
++++raw:+true
++};
++return+Table.getAll(criteria);
}|code-block|syntax|javascript|4643331|收益率：|4643332|{+some_id:+42,+some_count_sum:+100+},
{+some_id:+43,+some_count_sum:+150+}
...
etc.|4643333|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Example: how to add an convenient alias to the grouped function column.

I did this as a separate response mostly because it wouldn't format well in a comment... otherwise I would have just added it to Sampat's answer.

<pre><code>function getSumsBySomeId() {
 const criteria = {
 attributes: ['some_id', [sequelize.fn('sum', sequelize.col('some_count')), 'some_count_sum']],
 group: ['some_id'],
 raw: true
 };
 return Table.getAll(criteria);
}
</code></pre>

YIELDS:

<pre><code>{ some_id: 42, some_count_sum: 100 },
{ some_id: 43, some_count_sum: 150 }
...
etc.
</code></pre>

blocks|key|136766|text|您的代码应该类似于使用ES6标准的代码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|136767|Table.findAll({+attributes:+['column1',+sequelize.fn('count',+sequelize.col('column2'))],+++group:+["Table.column1"]++}).then(+(result)+=>+{+})|code-block|syntax|javascript|136768|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Your code should look something like these using ES6 standard. 

<pre><code>Table.findAll({ attributes: ['column1', sequelize.fn('count', sequelize.col('column2'))], group: ["Table.column1"] }).then( (result) =&gt; { })
</code></pre>

blocks|key|4643408|text|**试试这个*|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4643409|Table.findAll({
+++++group:+['column']
})|code-block|syntax|javascript|4643410|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

**Try this* 

<pre><code>Table.findAll({
 group: ['column']
})
</code></pre>

blocks|key|136817|text|创建一个查询，如|type|unstyled|depth|inlineStyleRanges|entityRanges|data|136818|SELECT+key,+COUNT(ref)+FROM+MyModel+GROUP+BY+key|code-block|syntax|javascript|136819|您可以按如下方式执行此操作|136820|++const+results+=+await+MyModel.findAll({
++++attributes:+['key',+[Sequelize.fn('COUNT',+Sequelize.col('ref')),+'count']],
++++group:+['key']
++});|136821|也可以将结果强制转换为类似于(MyModel+&+{+count:+number+})[]的格式|offset|length|style|CODE|136822|最后，要提取每一行的计数，需要使用getDataValue函数。例如：|136823|results.map(r+=>+r.getDataValue('count'))|136824|entityMap^0|0|0|0|0|E|V|0|H|C|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|10|8|@$M|11|N|12|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|13|8|@$M|14|N|15|O|P]]|9|@]|A|$]]|$1|S|3|T|5|D|7|16|8|@]|9|@]|A|$E|F]]|$1|U|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|V|$]]

To create a query like
<pre><code>SELECT key, COUNT(ref) FROM MyModel GROUP BY key
</code></pre>
You can do this as follows
<pre><code> const results = await MyModel.findAll({
 attributes: ['key', [Sequelize.fn('COUNT', Sequelize.col('ref')), 'count']],
 group: ['key']
 });
</code></pre>
Optionally you can cast the result to something like <code>(MyModel &amp; { count: number })[]</code>
Finally, to extract the count for each row, you'll need to use the <code>getDataValue</code> function. e.g.
<pre><code>results.map(r =&gt; r.getDataValue('count'))
</code></pre>

I am looking for <code>group by</code> queries through Sequelize and cannot seem to find any documentation.

<pre class="lang-sql prettyprint-override"><code> SELECT column, count(column) 
 FROM table 
 GROUP BY column
</code></pre>

How does group by works in sequelize?

我正在通过Sequelize查找group by查询，但似乎找不到任何文档。    SELECT column, count(column)      FROM table     GROUP BY column

问group by在sequelize中是如何工作的？
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问group by在sequelize中是如何工作的？EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问group by在sequelize中是如何工作的？
EN