Skip to main content
Priya Guleria 님이 #Apex에 질문했습니다
List<new_namespace__Account_Histroy__c> result=[select new_namespace__Account_Id__c,Count(Name) Name ,new_namespace__Account_Owner_New__c,new_namespace__Account_Owner_Old__c,

                                        new_namespace__Name_New__c,new_namespace__Name_Old__c,new_namespace__Account_Number_New__c,new_namespace__Account_Number_Old__c,new_namespace__Account_Website_New__c,

                                        new_namespace__Account_Website_Old__c,FORMAT(new_namespace__Modified_By_New__c) ModifyN,FORMAT(new_namespace__Modified_By_Old__c) ModifyO from new_namespace__Account_Histroy__c

                                        group By FORMAT(new_namespace__Modified_By_Old__c) ModifyO

                                        ];
답변 1개
  1. 2016년 11월 10일 오전 9:55
    Have you tried removing the last ModifyO? if your grouping by that FORMAT function then you don't need to alias it again:

     

    List<new_namespace__Account_Histroy__c> result=[select new_namespace__Account_Id__c,Count(Name) Name ,new_namespace__Account_Owner_New__c,new_namespace__Account_Owner_Old__c,

    new_namespace__Name_New__c,new_namespace__Name_Old__c,new_namespace__Account_Number_New__c,new_namespace__Account_Number_Old__c,new_namespace__Account_Website_New__c,

    new_namespace__Account_Website_Old__c,FORMAT(new_namespace__Modified_By_New__c) ModifyN,FORMAT(new_namespace__Modified_By_Old__c) ModifyO from new_namespace__Account_Histroy__c

    group By FORMAT(new_namespace__Modified_By_Old__c) ];

     
0/9000