Simple thing select roba , sifra, SUM ( ISNULL (kolicina, 0)) AS kolicina, mp_cijena from mp_kalkulacija_roba group by roba, sifra, mp_cijena Result roba sifra kolicina mp_cijena Pivo Nektar 0,33 l 534646 100.0000 2.0000 Tuborg 0.33 534646 24.0000 2.2500 Tuborg 0.33 534646 60.0000 2.5000 CEVAPI 324 25.0000 15.0000 Need sum this items kolicina column...withot group by mp_cijena

select roba , sifra, [kolicina]=(select SUM(ISNULL(kolicina, 0)) from mp_kalkulacija_roba),mp_cijena from mp_kalkulacija_roba

Please provide more detail with your example.

Please refer these links to know about SUM() function in detail. http://www.sqlservertutorial.net/sql-server-aggregate-functions/sql-server-sum/https://www.techonthenet.com/sql/sum.php

can you provide some sample data

Answers

Sum column MS SQL

Goran Bibic

Simple thing

select roba , sifra, SUM(ISNULL(kolicina, 0)) AS kolicina, mp_cijena
from mp_kalkulacija_roba
group by roba, sifra, mp_cijena

Result

roba sifra kolicina mp_cijena
Pivo Nektar 0,33 l 534646 100.0000 2.0000
Tuborg 0.33 534646 24.0000 2.2500
Tuborg 0.33 534646 60.0000 2.5000
CEVAPI 324 25.0000 15.0000

Need sum this items kolicina column...withot group by mp_cijena

Answers (4)

Next Recommended Forum

Select from multiple table MS SQL

Select from item table where id from list

Forum Statistics

Please welcome our newest member Nandita Singh.
3,091,830 users have contributed to 147,405 threads and 483,605
In the past 24 hours, we have 4 new threads, 9 new posts, and 176 new users.
In last week, the most popular thread is 'Fail to pass OrderId to the receipt'.

Upcoming Events

View all

Github Copilot Global Bootcamp - 2025
Live Discussion on Startups, AI, and Career Growth
Proactive Customer Support with Email Sentiment Analysis: Automate Your Business Processes - Ep.8