How to Compare SOQL Query Results [closed]

Question

For Example:

 for(Contact con : [Select Id,Salary__c From Contact Where AccountId = :accId Limit 100]){
            System.debug('Check min'+con.Salary__c);
 }

How to loop though the results and retrieve the minimum salary without changing my SOQL query?

Answer 1

Since you're just looking to compare it on the loop, you can use this:

Contact minSalCon;
Decimal minSal;
for(Contact con : [Select Id,Salary__c From Contact Where AccountId = :accId Limit 100]){
    System.debug('Check min'+con.Salary__c);
    if(minSal == null || con.Salary__c < minSal){
        minSal = con.Salary__c;
        minSalCon = con; //in case you need to do some logic on the contact
    }
}

Answer 2

Try with the below query:

for(AggregateResult agr : [Select AccountId accId, MIN(Salary__c) minSal From                
                           Contact Where AccountId =: accId Limit 100 group by AccountId]){
      System.debug('Check min'+agr .get('minSal'));
 }

You can use this query for multiple Accounts as well