Add a total row in store procedure

how do Add a total row to in a  store procedure, my query show;
meses enero febreo
item1   100     200
item2   150      250
I need to show
meses enero febreo
item1   100     200
item2   150      250
total     250     450
enrique_aeoAsked:
Who is Participating?
 
brad2575Connect With a Mentor Commented:
You can do a union on the query.

Note you may have to change the word 'total' in the second query so tha tit is ordered properly, you may need to call it 'zztotal' or something so it shows up as the last column in the sort order.

Select meses, enero, febreo From TableName
 
Union
 
Select 'total' as meses, Sum(enero), sum(febreo) From TableName
 
Order by meses

Open in new window

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
here we go:
select mese, enero, febreo
  from yourtable
union all
select 'total', sum(enero), sum(febro)
  from yourtable

Open in new window

0
 
sbagireddiCommented:
select sum(enero),sum(febreo)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.