CODEWITHSUNDEEP
sqlasp.net
dipu verma
dipu verma

Reputation: 1

select monthly report where per day transction show in single row

   Date -               Amount 
12-nov-2016              200
12-nov-2016              100
13- nov -2016            400
13 -nov-2016             200

result show like-

Date                     Amount 
12- nov-2016             300
13- nov-2016             600

as whole month

Upvotes: 0

Views: 34

Answers (1)

Damith
Damith

Reputation: 63065

select [Date], sum(Amount) as Amount from yourTable group by [Date]

Upvotes: 1

Related Questions