Skip to main content
Post Closed as "Needs details or clarity" by Gortonington, battery.cord, Pranay Jaiswal, Raul, Mohith Shrivastava
added 4 characters in body
Source Link
battery.cord
  • 8.9k
  • 8
  • 32
  • 59

I do the next SOQL and works:
SELECT FieldString FROM Account GROUP BY FieldString HAVING COUNT(FieldString)>1

SELECT FieldString FROM Account GROUP BY FieldString HAVING COUNT(FieldString)>1
  

But when I do the next SOQL doesn´tdoesn't work:
SELECT FieldDouble FROM Account GROUP BY FieldDouble HAVING COUNT(FieldDouble)>1

SELECT FieldDouble FROM Account GROUP BY FieldDouble HAVING COUNT(FieldDouble)>1  

Is it possible to make a format change for the SOQL to work? Or is there an alternative to making this SOQL work?
Thanks

I do the next SOQL and works:
SELECT FieldString FROM Account GROUP BY FieldString HAVING COUNT(FieldString)>1

But when I do the next SOQL doesn´t work:
SELECT FieldDouble FROM Account GROUP BY FieldDouble HAVING COUNT(FieldDouble)>1

Is it possible to make a format change for the SOQL to work? Or is there an alternative to making this SOQL work?
Thanks

I do the next SOQL and works:

SELECT FieldString FROM Account GROUP BY FieldString HAVING COUNT(FieldString)>1
  

But when I do the next SOQL doesn't work:

SELECT FieldDouble FROM Account GROUP BY FieldDouble HAVING COUNT(FieldDouble)>1  

Is it possible to make a format change for the SOQL to work? Or is there an alternative to making this SOQL work?

Source Link

Change format fields in SOQL

I do the next SOQL and works:
SELECT FieldString FROM Account GROUP BY FieldString HAVING COUNT(FieldString)>1

But when I do the next SOQL doesn´t work:
SELECT FieldDouble FROM Account GROUP BY FieldDouble HAVING COUNT(FieldDouble)>1

Is it possible to make a format change for the SOQL to work? Or is there an alternative to making this SOQL work?
Thanks