How to calculate using Column SQL Server

Question

I have Creating more than 10000 lines Using SQL Server.I inserted Many values.Now i want sum of Total based Expensive type value .

   ExpenseTypeCode      ExpenseType
    700300              Meals - FBR Only
    700450              Taxis/Parking/Tolls
    700450              Taxis/Parking/Tolls
    700300              Meals - FBR Only
    700300              Meals - FBR Only

i have this two fields and values.Now i want Sum of total using Expense type value .I want separate Total Like Taxis/Parking/Tolls total .how can calculate total based column value ?

Nitin Kumar · Accepted Answer · 2016-09-23 06:15:57Z

1

simply you can do like this

select ExpenseType,Total=Sum(ExpenseTypeCode) from YourTable
group by ExpenseType

answered Sep 23, 2016 at 6:15

Nitin Kumar

9087 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to calculate using Column SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related