function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
santhosh konathala 8santhosh konathala 8 

How to fetch minimum age value records in a query?here age is a field on object account.

Best Answer chosen by santhosh konathala 8
DeepthiDeepthi (Salesforce Developers) 
Hi Santhosh,

Try the below query: 
SELECT Age__c FROM Customer__c ORDER BY Age__c ASC NULLS Last LIMIT 10

If you require only one record to fetch then add "LIMIT 1" to the query.

Hope this helps you!
Best Regards,
Deepthi