How to calculate number of occurrence.

[Girish_123]

I have a column like this 

Col 1

mango

orange

mango

grape

orange

mango

orange

mango

apple

need an out put like 

mange 4

orange  3

Grape  1

Apple 1

[mahoneypat · Accepted solution]

In the query editor, select your Col 1 and hit the Group By button and accept the default aggregation of Count to get this.

Pat