Sign Up ›
  • Jigar Patel 31
  • NEWBIE
  • 5 Points
  • Member since 2022
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies
SOLVED
4 replies

The equivalent of "distinct" in SOQL does not work

I need to run a query but do not must return account id duplicated.

I followed these articles:
  • https://developer.salesforce.com/forums/?id=906F00000008yzrIAA
  • https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_groupby.htm
and this is my query:  
SELECT Id, AccountId FROM Asset GROUP BY AccountId

but this gives an error:  
[MALFORMED_QUERY] Field must be grouped or aggregated: Id

what do I need to change in my query to she works?
8 replies

How to Convert Excel File into CSV using Apex ?

Hi All,
I have a requirement in my code where I need to convert uploaded Excel file into CSV.
Can anyone tell me how to do this ?

Thanks and Regards,
Naznin