Solved I want a value (id) once inside the query

[Matin_Murad]

Hello everyone: Inside a query, a non-repeated record, but the value (id) is duplicate, I want a value (id) once inside the query

 

[pbaldy]

Is this what you want?

SELECT tabl2.id, tabl2.iname, Sum(tabl2.sales) AS SumOfsales
FROM tabl2
GROUP BY tabl2.id, tabl2.iname;

 

[Matin_Murad]

Thank you: this is what I need

 

[pbaldy]

No problem.