How can I know that the profile is custom or standard in salesforce through query?

Hello Pranav,

You can do like this:

List<String> stdProNames= new List<String>{'System Administrator','Standard User','Read Only','Solution Manager','Marketing User','Contract Manager'};
Profile[] customProfiles = [Select Id, Name from Profile where Name NOT IN :stdProNames];
System.debug(customProfiles);