+ Start a Discussion
Anik soni 7Anik soni 7 

There is a Question relate to SOQL

How to find out those accounts who's opportunity is more than 2? 
Best Answer chosen by Anik soni 7
Devi ChandrikaDevi Chandrika (Salesforce Developers) 
Hi Anik,
try this query
Select  account.Name,accountId from Opportunity group by account.name,accountId having count(id) > 2

Hope this helps you
If this helps kindly mark it as solved so that it may help others in future.

Thanks and Regards

All Answers

Devi ChandrikaDevi Chandrika (Salesforce Developers) 
Hi Anik,
try this query
Select  account.Name,accountId from Opportunity group by account.name,accountId having count(id) > 2

Hope this helps you
If this helps kindly mark it as solved so that it may help others in future.

Thanks and Regards
This was selected as the best answer
Rohit TantiRohit Tanti
nice info i,ll check many post but did,t find info but you post really helpful thank you so much and ye also check my <a href="https://newstatus.in/sun-pagli-status-in-hindi-new-pagli-status/">sun pagli status<a/> its very good status