Hello,
I am trying to create a soql like this:
SELECT Id, attr1, attr2, attr3
  FROM apiObject
  WHERE attr1 IN 
    (SELECT attr1 FROM apiObject  WHERE attr1 != null GROUP BY attr1, attr2, attr3 HAVING count(id) > 1)

But it shows this excepction:
ERROR at Row:2:Column:79
expecting a right parentheses, found 'GROUP'
Anybody could help me?
 

I call marketing cloud via apex, but i want that marketing cloud send diferents mail templates.
Thanks.

Hello, i am trying to read all data of object, like this:
var copyOpp = {!Opportunity};
Obviously it doesnt work, and i started with salesforce 2 weeks ago. My question is: 
Exists  something similar?
thanks

Hello,
I am trying to create a soql like this:
SELECT Id, attr1, attr2, attr3
  FROM apiObject
  WHERE attr1 IN 
    (SELECT attr1 FROM apiObject  WHERE attr1 != null GROUP BY attr1, attr2, attr3 HAVING count(id) > 1)

But it shows this excepction:
ERROR at Row:2:Column:79
expecting a right parentheses, found 'GROUP'
Anybody could help me?