# Counting occurrences of each email address in the database

**URL:** https://community.glideapps.com/t/counting-occurrences-of-each-email-address-in-the-database/75801
**Category:** Ask for Help
**Created:** [August 22, 2024, 7:16pm UTC](https://community.glideapps.com/t/counting-occurrences-of-each-email-address-in-the-database/75801 "2024-08-22T19:16:02Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Abhinav\_Hans](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@Abhinav\_Hans](https://community.glideapps.com/u/Abhinav_Hans)
#### Post date: [August 22, 2024, 7:16pm UTC](https://community.glideapps.com/t/counting-occurrences-of-each-email-address-in-the-database/75801/1 "2024-08-22T19:16:02Z")

</div>

Hi All,

I have different email address in the DB, I am trying to find out how many each email address’s count. Can anyone help me to get it.

Thank You

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 22, 2024, 11:45pm UTC](https://community.glideapps.com/t/counting-occurrences-of-each-email-address-in-the-database/75801/2 "2024-08-22T23:45:23Z")

</div>

You can do it like this:

- Create a relation from the email column to itself, make it a multiple match.
- Add a rollup \> count column on top of that relation.