SQL Server - SQL-how to use Rollup command in the following output
Asked By vinayak muru on 03-Dec-13 12:28 AM
I have table like,
create table vin(id int,coun char(20),amount int)
The above table have the record the like this,
id country amount
1 ind 200
2 ind 300
3 pak 400
4 ind 500
i just need a quantity column sum of the country.
I need a output for the below Format:
id country quantity amount
1 ind 3 200
2 ind 300
4 ind 500
3 pak 1 400