You need to sign in to do that
Don't have an account?

Select id,Min(age__c) from Contact GROUP BY Name
I have multiple contacts with their different ages. I want to fetch out minimum and max age among all contacts.
I tried this query....Select id,Min(age__c) from Contact GROUP BY Name.
please correct me
I tried this query....Select id,Min(age__c) from Contact GROUP BY Name.
please correct me
Try this:
Ex :
Hope this helps you!
If my answer helps resolve your query, please mark it as the 'Best Answer' & upvote it to benefit others.
Thanks
Varaprasad
@For SFDC Support: varaprasad4sfdc@gmail.com
Blog: http://salesforceprasad.blogspot.com/
Salesforce latest interview questions :
https://www.youtube.com/channel/UCOcam_Hb4KjeBdYJlJWV_ZA?sub_confirmation=1
All Answers
Try this:
Ex :
Hope this helps you!
If my answer helps resolve your query, please mark it as the 'Best Answer' & upvote it to benefit others.
Thanks
Varaprasad
@For SFDC Support: varaprasad4sfdc@gmail.com
Blog: http://salesforceprasad.blogspot.com/
Salesforce latest interview questions :
https://www.youtube.com/channel/UCOcam_Hb4KjeBdYJlJWV_ZA?sub_confirmation=1