1
Answer

Sum subquery MS SQL database

Goran Bibic

Goran Bibic
1y
374
1

Need to sum this column

(t.kolicina)*(sum(s.kolicina)) as 'Kol potr repromat'

When try

sum((t.kolicina)*(sum(s.kolicina))) as 'Kol potr repromat'

Have this error

Msg 130, Level 15, State 1, Line 2
Cannot perform an aggregate function on an expression containing an aggregate or a subquery.

My code

select t.naziv as 'Naziv' ,
  (t.kolicina)*(sum(s.kolicina)) as 'Kol potr repromat'
  from dbo.normativi_roba t
  full join
normativi_lista k
ON t.id_fakture =k.id
full join
mp_racun_roba s
ON k.naziv=s.roba
where roba=(select naziv from dbo.roba_usluge where podgrupa_artikala='HRANA' and roba_usluge.naziv=s.roba)
group by t.naziv, t.jedinica_mjere, t.kolicina

 

Answers (1)
Next Recommended Forum