+ 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,