Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Sum column MS SQL

Home
Forums
SQL

Sum column MS SQL

Goran Bibic

6yAsked Nov 11, 2019, 2:11 AM1.3kSQL

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Dhara Patel6y ago
Accepted answer
select roba , sifra, [kolicina]=(select SUM(ISNULL(kolicina, 0)) from mp_kalkulacija_roba),mp_cijena from mp_kalkulacija_roba
+1
Harsh Gupta6y ago
Please provide more detail with your example.
+1
Vrushali Ghodke6y ago
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
+1
Priyanka Jain6y ago
can you provide some sample data
+1