IOT Virtual Conference - Register now to book your ticket and get updates
x
CONGRATULATIONS! C# Corner Q1, 2021 MVPs Announced
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forumguidelines
Goran Bibic
716
2.4k
83.6k
Sum column MS SQL
Nov 11 2019 2:11 AM
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
Reply
Answers (
4
)
Select from multiple table MS SQL
Select from item table where id from list