how to correct group by id column - sql

Question

I have this query:

SELECT TwI_TwIId,
       TwI_TwrId,
       TwI_MagId,
       SUM(TwI_Ilosc) AS Ilosc,
       SUM(TwI_Wartosc) AS Wartosc,
       SUM(TwI_Braki) AS Braki,
       SUM(TwI_Rezerwacje) AS Rezerwacje,
       SUM(TwI_Zamowienia) AS Zamowienia
FROM cdn.TwrIlosci
WHERE twi_magid = 1
GROUP BY TwI_TwrId,
         TwI_TwIId,
         TwI_MagId
ORDER BY TwI_TwIId;

I don't know why but this query can't scale duplicate TwI_TwrId.

I have this result:

Answer 1

Because TwI_TwrId has unique TwI_TwIId for each, you need to exclude them from group by clause :

SELECT TwI_TwrId, TwI_MagId,
       SUM(TwI_Ilosc) AS Ilosc,
       SUM(TwI_Wartosc) AS Wartosc,
       SUM(TwI_Braki) AS Braki,
       SUM(TwI_Rezerwacje) AS Rezerwacje,
       SUM(TwI_Zamowienia) AS Zamowienia
FROM cdn.TwrIlosci
WHERE twi_magid = 1
GROUP BY TwI_TwrId, TwI_MagId;