News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Counts for accounts st...

Microsoft Dynamics CRM (Archived)

Counts for accounts starts with same name

(0) Share

Report

Report

Posted on by sandeepc

5,449

Need following from new CRM

Find counts for Accounts for xyz,abc We have multiple accounts in CRM for each of these. They might start with the same name

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

sandeepc 5,449 on at

Like (0)

Report

RE: Counts for accounts starts with same name
sandeepc 5,449 on at

Like (0)

Report

RE: Counts for accounts starts with same name

counts for Accounts for ATT, Ericsson, Centurylink (CTL), Verizon. We have multiple accounts in CRM for each of these. They might start with the same name eg. AT&T southeast, AT&T North etc.
sandeepc 5,449 on at

Like (0)

Report

RE: Counts for accounts starts with same name

SELECT

Name , COUNT(*)

FROM

Account

GROUP BY

name

HAVING

COUNT(*) > 1

WHAT ELSE I9 NEED TO ADD in this querry

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics CRM (Archived)

#1

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2

Community Member 52

#3

dkrishna 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans