renti

Group by - ExecuteSQL

Discussion created by renti on Nov 26, 2014
Latest reply on Nov 26, 2014 by renti

Hello,

 

I´ve a problem with the following sentence:

 

ExecuteSQL ("

Select SUM (Hours_employee) , Unique_mark

From T02_Partes_EMPLOYEES

Where date = ? AND Id_employee = ?

Group by Unique_mark

" ; "" ; "" ; date ; Id_employee)

 

 

I got the right result, but repeated for each row of the Group. I´d like to got just ONE result row for each group as i read it in the ExecuteSQL manual.

 

regards,

Outcomes