Salesforce Developer Community

Hello,

I am trying to get the second highest value in SOQL with below Query,

select Max(Age__C) from Patient__c Where Age__C NOT IN ( select MAX(Age__c) from Patient__c )

But am getting result with below Query

select Max(Age__C) from Patient__c Where Age__C NOT IN (23)