Hi to all,
i get the records from oracle database in below format
Date TotalBills TotalAmount
6-7-2014 1 100
6-7-2014 1 200
6-7-2014 1 300
6-8-2014 1 100
6-8-2014 1 400
6-9-2014 1 600
6-9-2014 1 200
but, i need bills count and total amount based on date,
please see below output. i need below output.
Date TotalBills TotalAmount
6-7-2014 3 600
6-8-2014 2 500
6-9-2014 2 800
Regards
Nanda Kishore.CH